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

2 answers

  • answered 2022-03-29 11:22 Koushik Roy

    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.

  • answered 2022-03-31 18:50 Maciejg

    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.

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum