How can u insert o ne row in the target if that row does not
exists in the target and update if it exists

Answer Posted / sailu

Do look up on the target with the key values. Check if the
look up is null or not. If look up value is null insert it
and if look up value is not null update it using update
strategy transformation with DD_UPDATE

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Briefly explain the aggregator transformation?

796


Differences between version 7.x and 8.x.

1663


What are the new features of informatica 9.x developer?

755


Explain the code page compatibility?

855


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1873


What are the components of the workflow manager?

903


Define joiner transformation?

830


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6452


draw informatica architecture 8.6 ?

3660


What is flashback table ? Advance thanks

1711


Explain the informatica workflow?

834


wat are deployement groups in informatica, how it will be used for developers

1479


How we can use union transformation?

826


How to extract sap data using informatica? What is abap? What are idocs?

838


What are the conditions needed to improve the performance of informatica aggregator transformation?

845