Why is operational data sometimes unusable for Business ...

[swpotter12]

Why is operational data sometimes unusable for Business Intelligence use?
 
  What will be an ideal response?

Question 2

Table column characteristics can be edited in the MySQL Table Editor.
 
  Indicate whether the statement is true or false

[Brenm]

Answer to Question 1

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.

Answer to Question 2

TRUE

[swpotter12]

TYSM

[diana chang]

Great answer, keep it coming