Explain why dimenstion tables are denormalized in nature?
No Answer is Posted For this Question
Be the First to Post Answer
Explain where do we use semi and non additive facts?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain what are slowly changing dimensions?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Explain me what is vldb?
what are different ways of loading data to data warehouse using oracle?
Which kind of index is preferred in DWH?
What is MODEL is Data mining world?
What is meant by metadata in context of a data warehouse and how it is important?
What is the difference between data warehouse and operational systems?
What are the types of dimensional modeling?
What is the difference between power center & power mart?