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 QuestionNext Question
What is data mart?What is data validation strategies for data mart v?