Yes, we should select Data Driven Option when we use Update Transformation in Informatica Mapping.When we select Target Load As option: Data Driven in Session Properties, then Update Transformation will Treat all insert records as Inserts and all Updates as Updates, and All deletes all Deletes.
Yes, we should select Data Driven Option when we use Update Transformation in Informatica Mapping.When we select Target Load As option: Data Driven in Session Properties, then Update Transformation will Treat all insert records as Inserts and all Updates as Updates, and All deletes all Deletes.
ReplyDeleteif not it will not work properly.