top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica: Confirmed Dimension, Junk Dimension, Degenerated Dimension, Slowly changing Dimensions?

+2 votes
414 views

Please explain in detail with example about Confirmed Dimension, Junk Dimension, Degenerated Dimension, Slowly changing Dimensions?

posted Jun 23, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Types of Dimensions in data warehouse

A dimension table consists of the attributes about the facts. Dimensions store the textual descriptions of the business. With out the dimensions, we cannot measure the facts. The different types of dimension tables are explained in detail below.

Conformed Dimension:

Conformed dimensions mean the exact same thing with every possible fact table to which they are joined.

Eg: The date dimension table connected to the sales facts is identical to the date dimension connected to the inventory facts.

Junk Dimension:

A junk dimension is a collection of random transactional codes flags and/or text attributes that are unrelated to any particular dimension. The junk dimension is simply a structure that provides a convenient place to store the junk attributes.

Eg: Assume that we have a gender dimension and marital status dimension. In the fact table we need to maintain two keys referring to these dimensions. Instead of that create a junk dimension which has all the combinations of gender and marital status (cross join gender and marital status table and create a junk table). Now we can maintain only one key in the fact table.

Degenerated Dimension:

A degenerate dimension is a dimension which is derived from the fact table and doesn't have its own dimension table.

Eg: A transactional code in a fact table.

Role-playing dimension:

Dimensions which are often used for multiple purposes within the same database are called role-playing dimensions.

For example, a date dimension can be used for “date of sale", as well as "date of delivery", or "date of hire"

answer Jun 25, 2015 by Manikandan J
Similar Questions
0 votes

i have created slowly changing dimension type 2 mapping in informatica mapping designer and i want to get active records from the loaded historical data with out using date,flag & version?

...