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