Scenario: During ETL testing, you encounter duplicate records in the target database that were not present in the source data. What could be the cause of this issue?
- Data Accuracy Issue
- Data Consistency Issue
- Data Duplication Issue
- Data Integrity Issue
This suggests a data integrity issue. Data integrity ensures the accuracy, reliability, and consistency of data throughout its lifecycle. In this scenario, the presence of duplicate records in the target database that were not in the source data indicates a failure in maintaining the integrity of the data during the ETL process.
Loading...
Related Quiz
- When optimizing queries with multiple JOINs and subqueries, it's essential to consider ____________ in order to achieve optimal performance.
- What is the primary objective of compliance and regulatory testing in the context of databases?
- In data consistency testing, what does it mean when we refer to "data reconciliation"?
- In data migration testing, what is the difference between a full load and an incremental load?
- What is a test script in the context of database automation frameworks?