Data Warehouse Data Mart Interview Question:

Explain What is data validation strategies for data mart validation after loading process?

Submitted by: Administrator

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.
Submitted by: Administrator