Informatica Process Source data Row - by - Row. it will treat mark each source record in Insert mode.if there are any Update Records/Delete records are needs to be updated in the Target table, then we should use Update Transformation.
When we use Update Transformation we should be use below options: DD_INSERT: if we set DD_INSERT(0) flag value in Update Transformation then all the Records entering into this Transformation will be Inserted into the Target table.
DD_UPDATE: if we set DD_UPDATE(1) then all the Records will go for Update in that particular flow.
DD_DELETE: all the records entere in to this pipeline will go for delete.
DD_REJECT: all the records which are entering into this pipeline floe will be rejected. thye will not be loaded into the target table.
Informatica Process Source data Row - by - Row. it will treat mark each source record in Insert mode.if there are any Update Records/Delete records are needs to be updated in the Target table, then we should use Update Transformation.
ReplyDeleteWhen we use Update Transformation we should be use below options:
DD_INSERT: if we set DD_INSERT(0) flag value in Update Transformation then all the Records entering into this Transformation will be Inserted into the Target table.
DD_UPDATE: if we set DD_UPDATE(1) then all the Records will go for Update in that particular flow.
DD_DELETE: all the records entere in to this pipeline will go for delete.
DD_REJECT: all the records which are entering into this pipeline floe will be rejected. thye will not be loaded into the target table.