Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What is update strategy transformation ?

asked marvit September 20, 2014 08:05 AM  

What is update strategy transformation ?


1 Answers

answered By Mswami   0  

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).

   add comment

Your answer

Join with account you already have



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!