how many ways can we implement SCD2?
Answers were Sorted based on User's Feedback
Answer / sbvp
1.FLAG
2.versioning
3.date range
there is three types to implement scd2.
Is This Answer Correct ? | 16 Yes | 1 No |
Answer / pune.rohitsharma
my ans is
1)date range
2)key
3)flag
here i have one thing to say
what about with pk key and with out pk will it come into
picture when we are talking about diff ways of implementing
SCD type 2
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / kumar raja kotakonda
1) FULL HISTORY
2) DATE RANGE
3) VERSINING
4) FLAGING
Is This Answer Correct ? | 2 Yes | 0 No |
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
what is Partitioning ? where we can use Partition?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
How do you promote a non-reusable transformation to reusable transformation?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
What are the new features of informatica 9.x in developer level?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
what is the process we used in joiner transformation,there is no matching column in sources?