Data Warehousing interview questions
Data Warehousing interview questions
Take as many assements as you can to improve your validate your skill rating
Total Questions: 5
1. In Star Schema Dimension tables are:
Correct Answer is : Short and Fat
2. The data in Data Warehouse is generally
Correct Answer is : Clean Data
3. In which type of SCD(Slowly changing dimensions) do we preserve history of data:
Correct Answer is : Type Two
4. During ETL load we generally have
Correct Answer is : Sorted data for Aggregator
5. Sequence of jobs to load data in to warehouse
Correct Answer is : First load data into dimension tables, then fact tables, then Aggregates if any
