Explain the definition of normalized and denormalized view and what are the differences between them?
973What are situations where snow flake schema is better than star schema to use and when the opposite is true?
1042Post New Data Warehouse General Questions
Why is business intelligence (bi) important in data warehousing?
What is the difference between agglomerative and divisive hierarchical clustering?
Explain can a dimension table contains numeric values?
What is a real-time data warehouse?
Explain the difference between keylokup and joiner?
Where we use surrogate key explain with example?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
What is drill-through?
What is the difference between constraind base load ordering and target load plan?
Store (and count) non-fact records?
What are Non-additive facts?
What are the steps involved in designing a fact table?
What are the types of partitioning?
What is surrogate key? Explain with examples.
The same tier?