How many project sources we can create in metadata?
What are aggregate fact tables ? why they are needed? give an example
Do you view contain data?
What are snapshots? What are materialized views & where do we use them?
Explain what is fact less fact table? Where you have used it in your project?
What Oracle features can be used to optimize my Warehouse system?
Explain dimension table ?
Explain what are necessary tasks to install reportnet software?
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
When should you use a STAR and when a SNOW-FLAKE schema?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What are the stages of datawarehousing?
Explain is olap databases are called decision support system true/false?