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?
Explain if a flat file cotains 1000 records how can I get first and last records only?
Explain what is fact less fact table? Where you have used it in your project?
What does level of granularity of a fact table signify?
What are the different methods of loading dimension tables?