Data in operational systems are typically fragmented and inconsistent.

More Questions from Data Warehousing

• Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
• Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
• Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
• Data in the data warehouse are loaded and refreshed from operational systems.
• Every key used to join the fact table with a dimensional table should be a surrogate key.
• Both status data and event data can be stored in a database.
• Joining is the process of partitioning data according to predefined criteria.
• Most operational systems are based on the use of transient data.
• Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.
• Independent data marts are often created because an organization focuses on a series of short-term business objectives.

Discussion & Comments