Explain degenerate dimension table?
What are loops in Datawarehousing?
What is freehand sql?
What is cubes?
Is there any default username & pwd for bo designer & supervisor?
Explain what is data validation strategies for data mart validation after loading process?
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?
What is the use of tabular model, tabular sql, tabular reference in real time application?
How to pivot row data using informatica?
What are the different types of join operations?
Explain functional dependency?
What is Discrete and Continuous data in Data mining world?
What is the use of dimensional modeling in data warehousing?
Do you view contain data?
What are the methodologies of data warehousing?
