Interested to Buy Any Domain ? << Click Here >> for more details...
what are the types of dimension tables
- 19 Answers
- 43793 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 |
Explain a mapping, session, worklet, workflow, mapplet?
What is ?Data Warehousing??
what is Materialized Views?
Explain what are necessary tasks to install reportnet software?
Explain about Control M JObs detaily?How to execute this.
2 Answers Scope International,
how much memory space occupied real time project (roughly)?
what is user variable in affinium campaign? and some real time examples.
What is cfapplication tag?
What according to you might be the future of data warehousing?
How do you define data block size?
How to handle multi value dimensions?
Explain dimension table ?
Teradata 
