|
Question |
Rating |
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 |
|
Which is the optimized method of extracting the data? |
|
View Answer |
|
What is data mining? |
|
View Answer |
|
What is real time data-warehousing? |
|
View Answer |
|
What are Data Marts? |
|
View Answer |