A data analyst is troubleshooting a report that shows unusually high sales for a specific product. Upon investigation, the analyst finds that the product was returned by several customers, but the returns were recorded in a separate system and not reflected in the sales data. Which data integration concept was likely missing?
Trap 1: ETL (Extract, Transform, Load)
ETL is a process, but the issue is lack of reconciliation, not ETL itself.
Trap 2: Data profiling
Profiling examines data quality, but doesn't fix cross-system consistency.
Trap 3: Data governance
Governance sets policies, but doesn't directly address reconciliation.
- A
ETL (Extract, Transform, Load)
Why wrong: ETL is a process, but the issue is lack of reconciliation, not ETL itself.
- B
Data reconciliation
Reconciliation ensures data matches across sources.
- C
Data profiling
Why wrong: Profiling examines data quality, but doesn't fix cross-system consistency.
- D
Data governance
Why wrong: Governance sets policies, but doesn't directly address reconciliation.