What is ods (operation data source)?
What is the difference between an ODS and a W/H?
Explain can report net connect multiple datasource at a time in report creation time?
What are cursors?
What are the steps involved in creating dimensional modeling process?
Explain the main difference between inmon and kimball philosophies of data warehousing?
What is the function of surrogate key in data warehousing?
what is table partitioning? How it is useful to warehouse database?
How to improve session performance in aggregator transformation?
What are the stages that are required in data warehousing?
Explain what are the possible data marts in retail sales?
What is the difference between drill through and masterdetail reports?
What are the steps to build the datawarehouse?