what are the types of dimension tables
- 19 Answers
- 38599 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 |
what are different ways of loading data to data warehouse using oracle?
What are the steps to build the datawarehouse?
What is normalization, first normal form, second normal form, third normal form?
Can we have more than one time dimensions in a Schema(Star or Snowflake)
What is Drill by? drill through?
Difference between e-r modeling and dimentional modeling?
Describe a data warehouse.
What Oracle tools can be used to design and build a W/H?
What is edw?
What is freehand sql?
Explain which are the olap tools available that are supported by oracle?
What is loop in data warehousing?
Teradata 
