Interested to Buy Any Domain ? << Click Here >> for more details...
what are the types of dimension tables
- 19 Answers
- 43818 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 is VLDB?
What are Fact tables and Dimension Tables?
What are the advantages and disadvantages of reporting directly against the database?
What is Time Series algorithm in data mining?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
3.What is fact less fact ?
9 Answers Accenture, HCL, TCS,
1.WHAT IS DATA MART ?
What is real-time datawarehousing?
Explain what is the metadata extension?
What is difference between query studio and report studio?
Explain what are components of reportnet?
what are the others of "bad files" and "discard files" when using sql*loader?
Teradata 
