Why we use Update Strategy transformation with DD_INSERT however Informatica automatically inserts the data without Update strategy transformation?
expecting the answer
2 Answers
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.
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.
Related