|
Related Questions |
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
|
|
Is it correct/feasible develop a Data Mart using an ODS?
|
View Answer
|
|
How are the Dimension tables designed?
|
View Answer
|
|
What is a CUBE in data warehousing concept?
|
View Answer
|
|
What is a look up table?
|
View Answer
|
|
What is Data warehousing Hierarchy?
|
View Answer
|
|
What is junk dimension? What are junk dimension and degenerated dimension?
|
View Answer
|
|
What is the main difference between Inmon and Kimball philosophies of data warehousing?
|
View Answer
|
|
What are the advantages data mining over traditional approaches?
|
View Answer
|
|
Can a dimension table contains numeric values?
|
View Answer
|
|
How do you connect two fact tables ?Is it possible ?
|
View Answer
|
|
What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?
|
View Answer
|
|
What are the similarities between ROLAP and MOLAP?
|
View Answer
|