top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

update a record in target table without using Update strategy using Informatica

+2 votes

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

posted Aug 19, 2013 by Luv Kumar

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

2 Answers

+1 vote

At the session level we can configure any of the below option to update the records-
1. Update as Update :- Update each row flagged for update if it exists in the target table.
2. Update as Insert :- Insert each row flagged for update.
3. Update else Insert :- Update the row if it exists. Otherwise, insert it.

answer Aug 19, 2013 by Shatark Bajpai
0 votes

on session properties there is an option " treat source row as ", First set this as "update". After it go to the mapping tab in session and choose target table. In target table properties you will have the following options.
update as update
update as insert
update else insert

If you want to apply only update operation then choose "update as update".

For Insert and update both choose" update else insert" and "insert".

For delete set "treat source row as" option as "delete" and at target level check "delete"strong textonly.

answer Aug 19, 2013 by Nandan Kumar
Similar Questions
+6 votes

Im working in a project which we create hundreds of xml's in informatica everyday, and all the data which is in the xml should be filtered, like removing all kind of special characters like * +.. You get the idea.

Adding regular expressions for every port is too complicated and not possible due the large amount of mapping we have.

I've added a custom property to the session XMLAnyTypeToString=Yes; and now i get some of the characters instead of &abcd, in their usual presentation (" + , ..).

I'm hoping for some custom property or change in XML target to remove these characters completely. any idea?

+1 vote

I have two sources (source A and Source B), source B is an another one target table in my db. both are in diff user id . Now i have to transfer some data,s from these two sources to target table. Can i transfer data without using the joiner transfermation? how to do ?