What are data modeling and data mining? Where it will be used?
What a static and local variable?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Explain the difference between keylokup and joiner?
What is Analysis Services?
Which kind of index is preferred in DWH?
What are data modeling and data mining?
What is the difference between view filter and report filter?
What are the advantages of query studio compared to report studio?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain difference between snow flake and star schema.
What is a star schema? Why does one design this way?
Explain a linked cube?