It is avaliable in lookup transformation. We need to enable dynamic lookup cache.
Insert else update:
- It will insert the row first and then update. If this option is disable it will insert the row as default
Update else insert:
- It its vice-versa of insert else update.
Note: There will be not much difference on Insert else update vs Update else insert.we need to decide this option depend on data.
![]() |
Insert else update vs Update else insert in Informatica |
Comments
Post a Comment