Author Question: In OLE DB, a RecordSet is a more abstract representation of a rowset. Indicate whether the ... (Read 33 times)

Ebrown · **on:** Jul 7, 2018

In OLE DB, a RecordSet is a more abstract representation of a rowset.

Indicate whether the statement is true or false

Question 2

Why is operational data sometimes unusable for Business Intelligence (BI) use? Include at least two examples.

What will be an ideal response?

kaillie · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

FALSE

Answer to Question 2

Data in operational databases can suffer from a number of problems. These include: (1 ) Dirty datadata that has problems with it, for example an age of 323; (2 ) Missing valuesdata values that are unknown, for example a person's age; (3 ) Inconsistent dataold data values that needed to be updated may not have beenfor example a ZIP code in an area that was split into two new ZIP codes; (4 ) Data not integratedwhen data from two or more data sets is used, the data may be from two or more different DBMSs; (5 ) Data in the wrong formatdata values may have been recorded at an inappropriate value for the needed analysisfor example, distance may have been recorded in miles when we need meters; (6 ) Too much datait is possible to simply have very large data sets in terms of records or fields.