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
Briefly explain the aggregator transformation?
Differences between version 7.x and 8.x.
What are the new features of informatica 9.x developer?
Explain the code page compatibility?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are the components of the workflow manager?
Define joiner transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
draw informatica architecture 8.6 ?
What is flashback table ? Advance thanks
Explain the informatica workflow?
wat are deployement groups in informatica, how it will be used for developers
How we can use union transformation?
How to extract sap data using informatica? What is abap? What are idocs?
What are the conditions needed to improve the performance of informatica aggregator transformation?