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

Informatica - Can we update a target table (without primary key) by using update strategy transformation?




1472
views
asked marvit September 20, 2014 07:58 AM  

Can we update a target table (without primary key) by using update strategy transformation?


           

1 Answers



 
answered By vishnoiprem   0  
Update Strategy is used to identify records which needs to be inserted/updated/deleted.
When you don't have a primary key and you want to do updates, Use update override option in the Target table. There you write the Update statement and mention the Update conditions using a where clause.
However, you need to take care of 2 things here.
1. Set the Treat Input rows as Update only(if your mapping is only updating the target. if its doing both insert and update set it as Data Driven)
2. Write the update statement in one single line without any line breaks
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