Hey I am net to informatica? Can any one explain me step by
step How scd will work ?



Hey I am net to informatica? Can any one explain me step by step How scd will work ?..

Answer / srinu

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

Post New Answer

More Informatica Interview Questions

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,


wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,


What is resilience time?

0 Answers  


What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,


what is data driven in informatica

5 Answers   IBM,






what are surrogate keys?

5 Answers  


write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,


Where do we use mapping variables in informatica?

0 Answers  


Explain transaction control transformation in informatica

0 Answers   Informatica,


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,


Sequence generator, when you move from develoment to production how will you reset

0 Answers  


how can import the data from the flat files?

2 Answers  


Categories