Update Strategy Transformation in Informatica, is a connected and active transformation. Till now you have seen that, most of the transformation in Informatica were use to insert the records. Update Strategy transformation let you insert, update , delete data from target Data also. It can also reject the incoming data depending upon your condition. For example : when a customer is changing address , you can use this update strategy transformation to update data in your Customer Tables.
Update Strategy Transformation is mainly used in Datawarehouse project to update the Target Database with the help of some Delta records (Changed data which need to be updated).
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!