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

Showing Answers 1 - 2 of 2 Answers

uma

  • May 3rd, 2006
 

Data validation is to make sure that the loaded data is accurate and meets the business requriments.

Strategies are different methods followed to meet the validation requriments

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions