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

I need to set predefined condition. How I do this?

507


Define data warehouse?

554


What is conformed fact?

630


Name a few sectors which use data warehousing?

524


How can you import tables from a database?

562






What are the fundamental elements of the data warehouse?

503


Explain what is the difference between stop and abort?

549


How can you communicate with web server (apache or iis) from coldfusion?

550


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

579


How to stop a batch?

547


Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

534


What is partitioning? What are the types of partitioning?

577


What is Cognos script editor?

2076


What is cubes?

623


Compare cold fusion with other programming languages?

561