Explain what are the different methods of loading dimension tables?
How to calculate fact table granularity?
What are Non-additive facts?
Explain what are the various reporting tools in the market?
What is drill-through?
How can we import and export using BCP utility?
What is the 4 + 1 view model as it relates to system modeling?
What are the difference between snow flake and star schema?
How to create diff. Types of templates?
What is the extension of file to save template?
Which columns go to the fact table and which columns go the dimension table?
What is the purpose of cluster analysis in data warehousing?
What is data stream and data adaopter. Is it same are different? Explain?