Author Question: Why is operational data sometimes unusable for Business Intelligence use? What will be an ideal ... (Read 78 times)

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

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 · **Reply #1 on:** Jul 7, 2018

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