What is a fact, dimension, measure?
No Answer is Posted For this Question
Be the First to Post Answer
Why facts table is useful in representing the data?
What is staging area?
what is the difference between DSS and ODS ?
How to load the time dimension?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is the difference between ods and oltp?
What is the difference between narmal load and bulk load?
What are the difference between snow flake and star schema?
Can we have more than one time dimensions in a Schema(Star or Snowflake)
Explain clustering algorithm?
what are different types of partitioning in oracle ?
Explain why denormalization is promoted in universe designing?