Why denormalization is promoted in universe designing?
Explain what are the various transformation available?
How to reduce warnings?
What is the difference between a primary and secondary actor in use case modeling?
Explain what is partitioning? What are the types of partitioning?
Explain meta data?
Explain why are oltp database designs not generally a good idea for a data warehouse?
Tell me what is full load & incremental or refresh load?
Explain is olap databases are called decision support system true/false?
How can we determine what records to extract?
What is a staging area? Do we need it? What is the purpose of a staging area?
Explain which are the olap tools available that are supported by oracle?
Explain some of modeling tools available in the market?
Explain what are non-additive facts?
Explain what is the difference between power center & power mart?