Author Topic: What is "Insert Else Update" and "Update Else Insert"?  (Read 410 times)

Offline QueryJunction

  • Administrator
  • Hero Member
  • *****
  • Posts: 717
  • Karma: +1/-0
    • View Profile
    • QueryJunction
What is "Insert Else Update" and "Update Else Insert"?
« on: March 22, 2012, 03:33:02 PM »
These options are used when dynamic cache is enabled.
[/size][/color]
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.[/l]
[/font][/color]
  • 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.
  • [/l][/font][/color]