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.
Explain what is aggregate table and aggregate fact table ... any examples of both?
Explain What is fact less fact table? where you have used it in your project?
Explain me what kind of costs are involved in Data Marting?
Tell us out of star schema and snowflake schema, whose dimension table is normalized?
Tell us what is Virtual Warehouse?
Tell us what does the Query Manager responsible for?
Can you list the Schema that a data warehouse system can implements?
Tell us what is the main difference between Inmon and Kimball philosophies of data warehousing?
Tell us what is Hybrid SCD?
Explain me why is chameleon method used in data warehousing?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
