For an ETL process that integrates data from multiple sources, what testing strategy ensures data accuracy and consistency?
- Data reconciliation testing, comparing source and target data
- Integration testing, verifying data flow across sources
- Regression testing, ensuring existing functionality remains intact
- Unit testing, validating each source individually
Data reconciliation testing is essential for an ETL process integrating data from multiple sources. It involves comparing source and target data to ensure accuracy and consistency, identifying any discrepancies in the transformation process.
Loading...
Related Quiz
- How does change data capture (CDC) impact the ETL process?
- What is the primary purpose of data validation in the ETL process?
- Post-execution, test reports are ________ to summarize findings and outcomes.
- What is the impact of data deduplication on the performance of ETL processes?
- What is the primary goal of data governance compliance in an organization?