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

What is standalone command task?

1016


How can you define user defied event?

820


Explain pushdown optimization $pushdownconfig parameter - informatica

915


Under what conditions selecting sorted input in aggregator will still not boost session performance?

835


How can one identify whether mapping is correct or not without connecting session?

1155


What are the types of caches in lookup?

780


How to generate sequence numbers?

822


What is event and what are the tasks related to it?

831


What is workflow monitor?

796


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?

776


What is the meaning of up gradation of repository?

1606


How can we use batches?

795


Separate from a database, an information bazaar, and an information stockroom?

833


How do we call shell scripts from informatica?

783


Can informatica load heterogeneous targets from heterogeneous sources?

942