hi there r 3 types of dimensions

1.star schema

2.snowflake schema

3.glaxy schema

i think there r 3 types of dimension table

1.stand-alone

2,local.

3.global

There are 3 types of dimensions available according to my knowledge.

That are

1. General dimensions

2. Confirmed dimensions

3. Junk Dimensions

Using the Slowly Changing Dimensions Wizard

The Slowly Changing Dimensions Wizard creates mappings to load slowly changing dimension tables:

• Type 1 Dimension mapping. Loads a slowly changing dimension table by inserting new dimensions and overwriting existing dimensions. Use this mapping when you do not want a history of previous dimension data.
• Type 2 Dimension/Version Data mapping. Loads a slowly changing dimension table by inserting new and changed dimensions using a version number and incremented primary key to track changes. Use this mapping when you want to keep a full history of dimension data and to track the progression of changes.
• Type 2 Dimension/Flag Current mapping. Loads a slowly changing dimension table by inserting new and changed dimensions using a flag to mark current dimension data and an incremented primary key to track changes. Use this mapping when you want to keep a full history of dimension data, tracking the progression of changes while flagging only the current dimension.
• Type 2 Dimension/Effective Date Range mapping. Loads a slowly changing dimension table by inserting new and changed dimensions using a date range to define current dimension data. Use this mapping when you want to keep a full history of dimension data, tracking changes with an exact effective date range.
• Type 3 Dimension mapping. Loads a slowly changing dimension table by inserting new dimensions and updating values in existing dimensions. Use this mapping when you want to keep the current and previous dimension values in your dimension table.

I want each and every one of you who is answering please don't make fun out of this.

some one gave the answer "no". some one gave the answer "star flake schema, snow flake schema etc"how can a schema come under a type of dimension

ANSWER:

One major classification we use in our real time modelling is

Slowly Changing Dimensions

type1 SCD: If you want to load an updated row of previously existed row the previous data will be replaced. So we lose historical data.

type2 SCD: Here we will add a new row for updated data. So we have both current and past records, which aggrees with the concept of datawarehousing maintaining historical data.

type3 SCD: Here we will add new columns.

but mostly used one is type2 SCD.

we have one more type of dimension that is

CONFORMED DIMENSION: The dimension which gives the same meaning across different star schemas is called Conformed dimension.

ex: Time dimension. where ever it was , gives the same meaning

wat r those three dimensions tht r available in inforamtica here we get multiple answers cud anyone tell me the exact once.........

thq

hari krishna