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
What is standalone command task?
How can you define user defied event?
Explain pushdown optimization $pushdownconfig parameter - informatica
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How can one identify whether mapping is correct or not without connecting session?
What are the types of caches in lookup?
How to generate sequence numbers?
What is event and what are the tasks related to it?
What is workflow monitor?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the meaning of up gradation of repository?
How can we use batches?
Separate from a database, an information bazaar, and an information stockroom?
How do we call shell scripts from informatica?
Can informatica load heterogeneous targets from heterogeneous sources?