what are the types of dimension tables

Answer Posted / chandrasekhar naidu

totally 9 types in dimensions
1.CASUAL DIMENSION
2.JUNK DIMENSION
3.DEGENERATED DIMENSION
4.SLOWLY CHANGING DIMENSION
5.SLOWLY GROWING DIMENSION
6.RAPIDLY GROWING DIMENSION
7.DIRTY DIMENSION
8.CONFIRMED DIMENSION
9.ROLE PLYING DIMENSION

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the differences between a data warehouse and data mart.

509


Explain datawarehousing?

555


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

567


Explain what is the advantages data mining over traditional approaches?

587


How to know the time taken for particular report execution?

520






Explain what is a staging area? Do we need it? What is the purpose of a staging area?

521


What is data analysis?

541


How to drill through from a powerplay cube to reportnet?

503


What is data analytics in simple terms?

556


Briefly state different between data ware house & data mart?

568


Whether dimension table can have numeric value?

609


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

536


What are the key columns in Fact and dimension tables?

552


What is data warehouse architecture?

579


What are the advantages of query studio compared to report studio?

510