top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica update partial data using UPDATE strategy

+1 vote
487 views

Is it possible to update partial data (primary key + just one or more columns) in a matching target row while leaving others intact in target as shown below or do I have to do a lookup and port all the columns?

enter image description here

posted Mar 18, 2014 by Pooja Bhanout

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+1 vote

Yes, simply only connect the required ports. Note, that you need to define in your target the ID column as primary key.

answer Mar 18, 2014 by Shweta Singh
0 votes

Use the Lookup/Joiner Transformation to identify the changed record and through Update Strategy Transformation update the desired columns in the target table. Make sure target table's ID column should be the primary key.

answer Apr 25, 2014 by Shatark Bajpai
Similar Questions
+2 votes

How can we update a record in target table without using Update strategy?

+2 votes

I have been trying a lookup and update strategy transformation but for some reason its not working.

I have a disconnected lookup in my mapping which is called based on a particular condition and when the look up is null , I tried to set a variable to 'INS',REJ,UPD,DEL..

The new variable in my agg_trans-INS_UPD_DEL is not getting linked to the upd_strategy trans. I'm able to move the variable from expression to update_strategy but dont see the link being displayed..

enter image description here

...