What are the different methods of loading dimension tables?
What is multi-dimensional analysis?
What is a star schema? Why does one design this way?
What is static and local variable?
Explain hybrid slowly changing dimension?
Could any one explain me how to create cascading prompts?
How many project sources we can create in metadata?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What is Grain & Granularity in Data Warehouse.
What is the metadata extension?
What are aggregate fact tables ? why they are needed? give an example
Explain if a flat file cotains 1000 records how can I get first and last records only?
What are data modeling and data mining? Where it will be used?