________ in a Data Warehouse helps in maintaining the history of data changes over time.
- Change Data Capture
- Dimension Table
- Fact Table
- Metadata
Change Data Capture (CDC) in a Data Warehouse is the process that helps in maintaining the history of data changes over time. It captures and tracks modifications to the data, providing a historical perspective for analysis.
Loading...
Related Quiz
- What kind of data anomaly occurs when there are contradictions within a dataset?
- In a scenario where data consistency is critical and the data volume is large, what data loading technique is most appropriate?
- Manual testing is often preferred when ________ is a key requirement.
- What role does version control play in maintaining the history of ETL test cases and scripts?
- If a critical issue is found in production, how can version control aid in quickly identifying and reverting to a stable state in ETL testing?