What is partitioning? What are the types of partitioning?
What is data type of the surrogate key?
What is prompt types of prompts?use of prompts syntax of prompt?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
Fact table is in normalized or de-normalized form?
How do we design a universe?
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
What is the difference between an ODS and a W/H?
explain about dirty dimension?
What are aggregate fact tables ? why they are needed? give an example
What is degenerate dimension table?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?