Correct option is C
Controlling metadata from being used interactively is not a typical control step in data warehousing applications. Metadata is essential for managing and understanding the structure and content of the data warehouse and is often accessed interactively for various tasks.
Important Key Points:
1.
Data Cleaning: A crucial step to ensure data accuracy and consistency before loading into the warehouse.
2.
Reconciliation: Ensures that data moved between operational systems and the data warehouse is accurate and complete.
3.
Metadata Usage: Metadata serves as the "data about data," helping users and systems navigate the warehouse effectively.
Knowledge Booster:
·
Summary Tables: Used to store aggregated data for faster querying.
·
Data Purging: Involves removing outdated or irrelevant data to optimize storage.
·
Metadata in Data Warehousing: Includes schema definitions, data lineage, and business rules for data usage.