|
Question |
Rating |
View Answer |
|
Explain the advanatages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs. |
|
View Answer |
|
Why should you put your data warehouse on a different system than your OLTP system? |
|
View Answer |
|
Why are OLTP database designs not generally a good idea for a Data Warehouse? |
|
View Answer |
|
How do you load the time dimension? |
|
View Answer |
|
Differences between star and snowflake schemas? |
|
View Answer |
|
What are conformed dimensions? |
|
View Answer |
|
What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables? |
|
View Answer |
|
What is SCD1 , SCD2 , SCD3? |
|
View Answer |
|
What is VLDB? |
|
View Answer |
|
What are conformed dimensions? |
|
View Answer |
|
What are non-additive facts? |
|
View Answer |
|
What are slowly changing dimensions? |
|
View Answer |
|
How are the Dimension tables designed? |
|
View Answer |
|
What does level of Granularity of a fact table signify? |
|
View Answer |
|
What is a level of Granularity of a fact table? |
|
View Answer |
|
Which columns go to the fact table and which columns go the dimension table? |
|
View Answer |
|
What type of Indexing mechanism do we need to use for a typical datawarehouse? |
|
View Answer |
|
What is ODS? |
|
View Answer |
|
What is Normalization, First Normal Form, Second Normal Form , Third Normal Form? |
|
View Answer |
|
What is data mining? |
|
View Answer |