what are the types of dimension tables

Answer Posted / nethaji

There are many dimension tables.
The commonly used are
Confirmed dimension,
Junk dimension,
Degenerated dimension,
Slowly changing dimension,
Rapidly changing dimension

The others are
Virtual dimension,
Regular dimension,
Casual dimension,
Shared dimension,
monster dimension.
These are used on certain condtions.

Is This Answer Correct ?    28 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

5478


What are Non-additive facts?

671


Explain what is the limit to the number of sources and targets you can have in a mapping?

555


What is the difference between connected and unconnected stored procedures?

562


I need a good brd and uc template?

595






What are the steps involved in designing a fact table?

506


Explain when do we analyze the tables? How do we do it?

624


How can we load the time dimension?

706


What is scd1 , scd2 , scd3?

690


Explain what is the metadata extension?

590


In document how to create metrics?

563


Can decision tree be implemented using SQL?

1667


What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

490


Explain me what are conformed dimensions?

546


What is hybrid slowly changing dimension?

642