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
difference between repository database and repository service?
Implementation methodology
Sequence generator, when you move from develoment to production how will you reset
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Parameter and variable differences
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
what is index?how it can work in informatica
Suppose we do not group by on any ports of the aggregator what will be the output?
What is meant by LDAP users?
How can we remove the duplicates from flat file source?
What is data movement mode in Informatica and difference between them?
How can informatica be used for an organization?
What is workflow? What are the components of the workflow manager?
How do you remove duplicate records in informatica? And how many ways are there to do it?
how many types of dimensions are available in informatica?