You are designing an Extract, Transform and Load (ETL) solution that loads data into dimension tables. The ETL process involves many transformation steps.
You need to ensure that the design can provide:
Auditing information for compliance and business user acceptance
Tracking and unique identification of records for troubleshooting and error correction
What should you do?
A. Develop a Master Data Services (MDS) solution.
B. Develop a Data Quality Services (DQS) solution.
C. Create a version control repository for the ETL solution.
D. Develop a custom data lineage solution.
