Informatica Reference

What is “Insert Else Update” and “Update Else Insert”?

Posted on: 12/16/2011

These options are used when dynamic cache is enabled.

  • Insert Else Update option applies to rows entering the lookup transformation with the row type of insert. When this option is enabled the integration service inserts new rows in the cache and updates existing rows. When disabled, the Integration Service does not update existing rows.
  • Update Else Insert option applies to rows entering the lookup transformation with the row type of update. When this option is enabled, the Integration Service updates existing rows, and inserts a new row if it is new. When disabled, the Integration Service does not insert new rows.
About these ads
Follow

Get every new post delivered to your Inbox.

Join 38 other followers

%d bloggers like this: