what are the types of dimension tables
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 |
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is Active Datawarehousing?
what role views play in dimensional modeling?
Whether dimension table can have numeric value?
Why is chameleon method used in data warehouse?
What is Cognos script editor?
What is a look up function? What is default transformation for the look up function?
can anybody mail me the FAQS for hyperion essbase amd planning
What is partitioning? What are the types of partitioning?
Hierarchy of DWH?
2 Answers Accenture, EDS, IBM, iFlex, TCS,
Explain difference between view and materialized view?
What is the use of tabular model, tabular sql, tabular reference in real time application?