Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions
Answer Posted / 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 |
Post New Answer View All Answers
What are active and passive transformations?
Explain the types of lookup transformation?
expain about the tune parameters?
Why update strategy and union transformations are active? Explain with examples.
Where is metadata stored?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the different options available for update strategy?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Briefly define a session task?
What do you understand by SOA of Informatica?
what are the Methods For Creating Reusable Transformations?
What is meant by target load plan?
What is the command used to run a batch?
lookup transformation with screenshots
Explain the types of transformations?