what are the types of dimension tables

Answer Posted / pavithra

a) Primary dimension table
b) Secondary dimension table
c) Degenerate dimension table
d) Conformed dimension table
e) Slowly changing dimension table
f) Rapidly changing slowly dimension table
g) Large dimension
h) Rapidly changing monster dimension
i) Junk dimension
j) Role playing dimension

Is This Answer Correct ?    6 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How are the dimension tables designed?

557


What are the stages that are required in data warehousing?

509


Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

512


Explain about core dimension,

532


Explain what is the advantages data mining over traditional approaches?

574






What needs to be done while starting the database?

646


Why denormalization is promoted in universe designing?

548


what are the major three types of modeling used?

610


Explain the hierarchies level data warehousing.

501


Explain what are slowly changing dimensions?

607


How to create diff. Types of templates?

554


Explain what is the difference between a primary and secondary actor in use case modeling?

656


What do you mean by static and local variable?

521


What are session timeout and application timeout? Where we have to do this process?

592


What are the differences between datamart vs. Reporting cube?

479