What is the main difference between schema in rdbms and schemas in datawarehouse?
What is surrogate key? Where we use it explain with example?
Explain can a dimension table contains numeric values?
What is crass reference table?
What is a fact, dimension, measure?
Explain difference between e-r modeling and dimentional modeling?
Explain the definition of normalized and denormalized view and what are the differences between them?
Explain the definition of normalized and denormalized view?
Explain why fact table is in normal form?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Explain dimensional modelling?
What is batch processing?
What is aggregate fact table?
Suggest a good author for hyperion in data warehousing?
What is metadata in context of a datawarehouse and how it is important?