Dimensions are of 3 types mainly in case of slowly changing dimensions:

Type 1 ->Doesnt maintain any history and is update only.

Type 2-> Maintains full history.Insert row when certain attributes change else update row.The latest record is identified by a flag or date field which is called the MRI or Most Recent Indicator

Type 3->Maintains partial history.History is maintained as columns and not rows.Hence it is predecided as to till how many levels of history you want to maintain.

 infromational dimension

strutral dimension

conformed dimesion

There are three types of Dimesions

Confirmed Dimensios, Junk Dimesions, Degenerative Dimesions

Comfirmed is some thing which can be shared by shared by multiple Fact Tables or multiple Data Marts.

Junk Dimensiions is grouping flagged values

Degenerative Dimension is something dimensional in nature but exist fact table.

Hi prathiba,

can you tell me how the dimenions are seperated?

Sithu

sithusithu@hotmail.com

there are five types of dimensions:

1. star schema

2. snowflake schema

3.parent-child schema

4.virtual dimension

5. mining model

Hi,

 Can u detail ab't 3 dimensions.

regards

Amit

What is this? No one know waht are the diffrent types of dimesnsions? Who's answer is correct, everyone is giving there own answers.

Actually the question is wrong and is not mentioned in which case it is talking about.

I think there are following types of dimensions:

1. SCD or slowly changing dimension.

2. SGD or slowly Growing Dimension. ( Type 1, Type 2 and Type 3)

There are other three types of Dimensions:

1. Confirmed Dimensions.

2. Junk Dimensions.

3.  Degenerative Dimensions.

Regards,

Ashish Sharma

can you explain in detail the following with examples:

1. junkdimension

2.conformed dimension

3degenarative dimension.