Its very much possible to update the target table without using the update strategy transformation. In Informatica session we have option to enable this.
Open Informatica session , navigate to properties and set Treat source rows as ‘Update’ .
Then open Informatica session, navigate to Mapping and set target as "Update as update" Only.
But remember, It will always update the all the columns of target table with the data will come from source. Single column is not possible to update using this option.
Please put your comments !!
No comments:
Post a Comment