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

[Ebrown]

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]

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.

[Ebrown]

Excellent

[anyusername12131]

TYSM