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

Informatica - What is update strategy transformation ?




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

flag   
   add comment

Your answer

Join with account you already have

FF

Preview


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!

Alert