what are the types of dimension tables

Answer Posted / raghavendra

There are four types of dimensions

1.Conformed Dimension
2.Junk Dimension
3.Degenerate Dimension
4.Role-Playing Dimensions

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why facts table is useful in representing the data?

502


Explain conformed fact?

527


Explain what are the different types of data warehousing?

519


How to improve session performance in aggregator transformation?

534


What are the steps involved in designing a fact table?

500






Explain multivalued dependency?

573


Explain hybrid slowly changing dimension?

575


What is the difference between static cache and dynamic cache?

524


How to test report in reportnet?

568


What are the different types of scd's used in data warehousing?

615


what is an use case?

624


Explain how to get the first 100 rows from the flat file into the target?

524


Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

506


Explain what are the basic needs to join two sources in a source qualifier?

521


What is a Decision Tree Algorithm?

4546