What is XMLA ?
How to pivot data using informatica when you have variable amount of pivot rows?
How to load the time dimension?
Explain how to get the first 100 rows from the flat file into the target?
In document how to create metrics?
Explain what are fact, dimension, and measure?
Explain where do we use semi and non additive facts?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is static and local variable?
What are data modeling and data mining? Where it will be used?
What are the stages that are required in data warehousing?
Explain what are non-additive facts in detail?
What is the main difference between star and snowflake star schema? Which one is better and why?