Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions

Answers were Sorted based on User's Feedback



Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerat..

Answer / raveendra g

One dimension which used more than one cube called
Confirmed dimension.
Junk dimension is nothing but Durty. We have to take
unrelated attributes and data into maintain single table
called junk dimension.
DD: The value of the dimension which is stored in the
factable called Degenerated Dimension
SCD: The value of the dimension is happen to change very
rarely and commonly called SCD.
3 Types of SCDS we are having
SCD1: Only current
SCD2: Current+History, Here we can add rows
SCD3: Current+just recent, Here we can add columns level
data.

Is This Answer Correct ?    4 Yes 0 No

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerat..

Answer / usha

1.Confirmed Dimension:- the dimensions that are bult once
and can be use reused in multiple fact tables

2.Junk Dimension:- the dimension which is used to cerate
junk attributes

3.Degenerated Dimension:- The dimension that are located
in fact table


4.Slowly changing Dimensions:- The dimensions that chaanfes
slowly over a period of time.

Types

SCD type1
SCD type2
SCD type3

Is This Answer Correct ?    0 Yes 0 No

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerat..

Answer / vasu

check all pevious Questions and Answers in
Allinterview.com

Is This Answer Correct ?    1 Yes 9 No

Post New Answer

More Informatica Interview Questions

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,


Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,


can every transfomation reusable?how?

2 Answers   Wipro,


what is the Default Source Option For Update Strategy Transformation?

0 Answers   Informatica,


how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,






Explain the tuning lookup transformation - informatica

0 Answers   Informatica,


Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  


How does a sorter cache works?

0 Answers  


HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,


How to recover the standalone session?

2 Answers  


What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,


What is router transformation

4 Answers   CSC,


Categories