what are different ways of loading data to data warehouse
using oracle?
How to define a cube??
What are algorithms provided by Microsoft in SQL Server?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain difference between e-r modeling and dimentional modeling?
what is difference between drill & scope of analysis?
What is critical column?
Explain the difference between data ware house & data mart?
Explain what is ods (operation data source)?
Which is the optimized method of extracting the data.
Tell me what is full load & incremental or refresh load?
What is metadata in context of a datawarehouse and how it is important?
Explain what is data validation strategies for data mart validation after loading process?