The role of the ETL process is to identify erroneous data and to fix them.

More Questions from Data Warehousing

• A data mart is designed to optimize the performance for well-defined and predicable uses.
• Data in operational systems are typically fragmented and inconsistent.
• 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.

Discussion & Comments