Data Warehouse Data Mart Question: Download Questions PDF
Explain What is data validation strategies for data mart validation after loading process?
Answer:
Data validation is generally done manually in DWH in this case if source and TGT are relational you need to create SQL scripts to validate source and target data and if source is Flat file or non relational database you can use excel if data is very less or create dummy tables to validate your ETL code.
Download Data Mart Interview Questions And Answers
PDF
Previous Question | Next Question |
What is data mart? | What is data validation strategies for data mart v? |