Interested to Buy Any Domain ? << Click Here >> for more details...
what are the types of dimension tables
- 19 Answers
- 43059 Views
- Infotech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chol thakur
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions.
| Is This Answer Correct ? | 85 Yes | 10 No |
Answer / venky
There are 10 types of dimensions..
1) Primary Dimensions
2) Secondary Dimensions
3) Degenerate Dimension
4) Conformed Dimension
5) Slowly Changing Dimension
6) Rapidly Changing Small Dimension
7) Large Dimension
8) Rapidly Changing Monster Dimension
9) Junk Dimension
10) Role-playing Dimension
| Is This Answer Correct ? | 20 Yes | 2 No |
Answer / nethaji
There are many dimension tables.
The commonly used are
Confirmed dimension,
Junk dimension,
Degenerated dimension,
Slowly changing dimension,
Rapidly changing dimension
The others are
Virtual dimension,
Regular dimension,
Casual dimension,
Shared dimension,
monster dimension.
These are used on certain condtions.
| Is This Answer Correct ? | 28 Yes | 15 No |
Answer / annu
Rapidly changing dimensions,
confirmed dimensions,
slowly changing dimensions and
slowly growing targets
| Is This Answer Correct ? | 20 Yes | 11 No |
Answer / 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 |
Answer / 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 |
Answer / gattu srinivasarao
Types of Dimentions are
1.slowly changing dimention
2.conformed dimention
3.rapidly changing dimention
4.junk dimenstion
5.degeerated dimention
6.large dimentions
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / 9885657928
Conformed dimentions,
Junk diementions,
Durty dimentions
| Is This Answer Correct ? | 7 Yes | 7 No |
Answer / suresh
Types of Dimensional tables:
1)Junk Dimensions
2)Degenerated Dimensions
3)Casual Dimensions
Regards,
Suresh
| Is This Answer Correct ? | 2 Yes | 2 No |
How we are using this function?
How can we transform row to column?
What is the difference between view materialized view and view?
What is cubes?
Explain is olap databases are called decision support system true/false?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
How to get the first 100 rows from the flat file into the target?
where exactly in dataware house a confirmed dimension can be created
What is the main difference between star and snowflake star schema? Which one is better and why?
What Oracle features can be used to optimize my Warehouse system?
What is a data profile?
Explain what are data marts?
Teradata 
