Interested to Buy Any Domain ? << Click Here >> for more details...
what are the types of dimension tables
- 19 Answers
- 43794 Views
- Infotech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srikanth
They are total 11 dimensionals
we frequently used only 5 dimension they are
1. normal dim
2. dynamic dim
3. junk dim
4. degenrated dim
5. confirmed dim
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / aravalli rajasekhar
There are many types of dimensions
conformed dimesion:
the dimension which are maintain the relation ship between
two are more fact table are called conformed dimension.
eg: galaxy schema
shrunk dimesion:
the dimnesion which does not maintain the direct relation to
fact table is called shrunk dimesion
junk dimesion:
the dimesion which are maintain the relation ship low
coradinality values is called junk dimension
eg: the dimsion apply on dimesion gender
rolepaly dimesion:
the dimesion which are occred more than two dimension tables
are called rolepaly dimension
eg: time appear frequently all dimension tabsles
dirt dimesoion:
the dimesion which are already occred in the fact table
but again apper with version change those dimension are
called dirty dimesion
eg: SCD2
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ravi katariya
types of dimensional table
type 1dimension
type 2dimension
type 3dimension
time dimension
srunk dimension
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pallavi
different types of dimension tables are:
1.regular dimensions
2.composite dimension hierarchy
3.range time based
4.conformed dimension
5.junk dimension
6.degenerate dimension
7.role playing dimension
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / chandrasekhar naidu
totally 9 types in dimensions
1.CASUAL DIMENSION
2.JUNK DIMENSION
3.DEGENERATED DIMENSION
4.SLOWLY CHANGING DIMENSION
5.SLOWLY GROWING DIMENSION
6.RAPIDLY GROWING DIMENSION
7.DIRTY DIMENSION
8.CONFIRMED DIMENSION
9.ROLE PLYING DIMENSION
| Is This Answer Correct ? | 1 Yes | 4 No |
Answer / hidayathulla
Types of Dimensional tables
1 slowly changing dimensions
2 type1 dimensions
3 type2 dimensions
4 type3 dimensions
5 Zunc dimensions
6 confirmed dimensions
| Is This Answer Correct ? | 1 Yes | 4 No |
Answer / carlos siao
TABULAR DIMENSION
STAGEREG DIMENSION
BASELINE DIMENSION
COORDINATES
GROUP DIMENSION
CONTOUR DIMENSION
CENTER LINE
| Is This Answer Correct ? | 6 Yes | 29 No |
Answer / anitha
1.star schema
2.snowflake schema
3.glaxy schema
| Is This Answer Correct ? | 7 Yes | 70 No |
What is the 4 + 1 view model as it relates to system modeling?
Is it possible to have more than one row on the same table with the same foreign key?
Tell me what is full load & incremental or refresh load?
Where do we use semi and non additive facts?
What are the advantages of raid 1, 1/0, and
Why is chameleon method used in data warehouse?
How to load the time dimension?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
What is the difference between olap and oltp?
In microstrategy, how can we direct the sql generated to use a specifc table?
The same tier?
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
Teradata 
