1.Identify and discuss the problems which are occurred
during data quality verification for the single-source and
multi-source problems.
2.Testing has very important role in DWH. In ETL testing
phase, how can we perform the integration testing and
regression testing?
3.What are the perquisites of system testing and regression
testing in ETL phase?
How many steps etl contains explain with example?
what is the difference steps for data modeling?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
Difference between flat files and relational sources?
what is different between sequential batch and concurrent batch and which is recommended and why?
how do u set partition points in the mapping?
What are the modules in Power Mart?
What is a staging area? What is the purpose of a staging area?
how would u estimate the size of Aggregator transform data and index cache?
What is Data Vault???
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
what are the concerns of OLTP and DSS systems?