Explain the definition of normalized and denormalized view and what are the differences between them?
568What are situations where snow flake schema is better than star schema to use and when the opposite is true?
590Post New Data Warehouse General Questions
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Start a batches with in a batch?
How to generate the cubes in framework manager?
Explain is fact table?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Why null values are mapped as 0 in fact tables?
Explain what is the difference between power center & power mart?
What is the difference between aggregate table and materialized view?
How are models actually derived?
What is a general purpose scheduling tool?
What is metadata in context of a datawarehouse?
Is union transormation is active transformation?
I need to set predefined condition. How I do this?
How to reduce warnings?
What are the fundamental elements of the data warehouse?
