what are the types of dimension tables

Answer Posted / dhana

There are

1. Multi value Dimension
2. Role playing Dimension
3. Slowly changing Dimension
4. Garbage Dimension or Junk Dimension
5. Fastly Changing Dimension
6. Conformed Dimension

Regards,
Dhana

Is This Answer Correct ?    4 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

506


What is a real-time data warehouse?

584


What is the difference between constraind base load ordering and target load plan?

643


What are the different problems that ?Data mining? can solve?

2347


What are the methodologies of data warehousing?

569






After we create a scd table, can we use that particular dimension as a dimension table for star schema?

545


What is cubes?

615


Store (and count) non-fact records?

517


Can we take backup when the database is opened?

576


Explain what is full load & incremental or refresh load?

526


What are the steps of implementing data warehousing?

530


What is data stream and data adaopter. Is it same are different? Explain?

490


I have two universes created by two difference database can we join them in designer & report level? How

529


what is an use case?

613


Code the tables statement to produce a multi-level frequency?

542