Answer Posted / pallavi
different types of dimension tables are:
1.regular dimensions
2.composite dimension hierarchy
3.range time based
4.conformed dimension
5.junk dimension
6.degenerate dimension
7.role playing dimension
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to drill through from a powerplay cube to reportnet?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
List any five applications of data warehouse.
What are the differences between star and snowflake schema?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
What are partition points?
How do you create surrogate key using ab initio?
How are models actually derived?
What is core dimension?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What do you mean by static and local variable?
What are Non-additive facts?
What is the working process for application.cfm?
what are the other factors of the database on which the loading performance depend?
Explain bus schema?