Answer Posted / raghavendra
There are four types of dimensions
1.Conformed Dimension
2.Junk Dimension
3.Degenerate Dimension
4.Role-Playing Dimensions
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Explain what are the vaious etl tools in the market?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What are the different types of data warehousing?
What are the different methods of loading dimension tables?
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?
Explain swot analysis?
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?
How many types of facts and what are they?
What are the different models used in cluster analysis?
How can you import tables from a database?
What is VLDB?
What are session timeout and application timeout?
What is the difference between aggregate table and materialized view?
What is the differences between star and snowflake schemas?