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?
Explain what are the modules in power mart?
Explain what is ods (operation data source)?
Explain difference between data ware house & data mart?