Hey I am net to informatica? Can any one explain me step by
step How scd will work ?
Selects all rows.
Caches the existing target as a lookup table.
Compares logical key columns in the source against
corresponding columns in the target lookup table.
Compares source columns against corresponding target
columns if key columns match.
Flags new rows and changed rows.
Creates two data flows: one for new rows, one for changed
rows.
Generates a primary key for new rows.
Inserts new rows to the target.
Updates changed rows in the target, overwriting existing
rows.
Is This Answer Correct ? | 6 Yes | 2 No |
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
What is resilience time?
What is a surrogate key?Why we use it in a mapping?Pl give an example.
what is data driven in informatica
what are surrogate keys?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
Where do we use mapping variables in informatica?
Explain transaction control transformation in informatica
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Sequence generator, when you move from develoment to production how will you reset
how can import the data from the flat files?