"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What is a fact, dimension, measure?
Is there any rownum object from which we can do this?
Explain the main differences between star and snowflake schema?
List any five applications of data warehouse.
ware house management system is used?
Explain what is fact less fact table? Where you have used it in your project?
How do you define data block size?
Name a few sectors which use data warehousing?
How we are using this function?
How can we determine what records to extract?
What are diagrams?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What are situations where snowflake schema is better than star schema when the opposite is true?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?