Interested to Buy Any Domain ? << Click Here >> for more details...
Hey I am net to informatica? Can any one explain me step by
step How scd will work ?
- 1 Answers
- 7611 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
how to create user defined function (udf) in informatica
What is a node in Informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Explain lookup transformation in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the reusable transformations?
While migrating the data from one environment to another environment how would you manage the connections?
Under which circumstances, informatica server creates reject files?
How can we create index after completion of load process?
What do you mean incremental aggregation?
What is sq transformation?
wat are deployement groups in informatica, how it will be used for developers
Mention few power centre client applications with their basic purpose?
How to improve the performance of a session using sorter transformation?
Can we create multiple integration service on single repository?
