Data Warehousing Questions

• 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.
• Static extract is used for ongoing warehouse maintenance.
• Periodic data are data that are physically altered once added to the store.