'Update Strategy with DD_INSERT
Why we use Update Strategy transformation with DD_INSERT however Informatica automatically inserts the data without Update strategy transformation?
expecting the answer
Solution 1:[1]
Its a tool - and many logic demands different kind of behavior.
Your assumptions Informatica automatically inserts the data is for default behavior with all settings left as default. If someone wants to insert, update, delete, reject - they can use different options in update strategy. You also need to set the session to data driven.
If you put only dd_insert, this means this pipeline is used only for inserting.
Solution 2:[2]
If a mapping performs single type of operation AND it's not driven by the data, then Update Strategy transformation is not at all required.
And it's not even for inserts only, as this is driven by the Treat input rows as session property [more information can be found here].
Furthermore, it's possible to specify general approach for the whole session and then override it for particular targets, if needed. Still without using Update Strategy transformation.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Koushik Roy |
| Solution 2 | Maciejg |