what are the types of dimension tables

Answer Posted / venky

There are 10 types of dimensions..

1) Primary Dimensions
2) Secondary Dimensions
3) Degenerate Dimension
4) Conformed Dimension
5) Slowly Changing Dimension
6) Rapidly Changing Small Dimension
7) Large Dimension
8) Rapidly Changing Monster Dimension
9) Junk Dimension
10) Role-playing Dimension

Is This Answer Correct ?    20 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is "method/1"?

595


What are situations where snowflake schema is better than star schema when the opposite is true?

565


How to create context?

604


What is informatica architecture?

612


Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

517






how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

1728


What is the main difference between inmon and kimball philosophies of data warehousing?

663


Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

646


What are the types of partitioning?

580


What is an error log table in informatica occurs and how to maintain it in mapping?

567


Name a few sectors which use data warehousing?

524


What are the types of dimensional modeling?

622


What are the advantages of raid 1, 1/0, and

533


What are session timeout and application timeout?

531


What function should we use to display the value entered or selected by a user in response to a prompt?

516