Update else Insert in Informatica

In order to successfully implement upsert using Informatica we need to follow these steps:

  1. In the mapping we need an update strategy with DD_UPDATE before the Target.
  2. In the session the we need to have the following settings:
    1. Under Properties:Treat Source rows as Data driven
    2. Under Mapping, the Target should have both Insert and Update else insert checked.

I do not recommend update else insert for large sets of data if you need a process that is efficient and fast. It is better to stick with having two separates paths in the mapping. One for updates and the other one for Inserts.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>