|
Related Questions |
View Answer |
|
What is degenerate dimension table?
|
View Answer
|
|
What is the datatype of the surrogate key ?
|
View Answer
|
|
What is VLDB?
|
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
|
|
Name some of modeling tools available in the Market?
|
View Answer
|
|
What is a general purpose scheduling tool?
|
View Answer
|
|
What type of Indexing mechanism do we need to use for a typical data warehouse?
|
View Answer
|
|
What are non-additive facts?
|
View Answer
|
|
What is conformed fact?
|
View Answer
|
|
What are the Different methods of loading Dimension tables?
|
View Answer
|
|
What are conformed dimensions?
|
View Answer
|
|
What are the various Reporting tools in the Market?
|
View Answer
|
|
Why are OLTP database designs not generally a good idea for a Data Warehouse?
|
View Answer
|
|
What is SCD1 , SCD2 , SCD3?
|
View Answer
|
|
What does level of Granularity of a fact table signify?
|
View Answer
|
|
What is ETL?
|
View Answer
|
|
Why is Data Modeling Important?
|
View Answer
|
|
Why should you put your data warehouse on a different system than your OLTP system?
|
View Answer
|
|
What is ODS?
|
View Answer
|
|
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
|
View Answer
|