top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to update the target table without using update strategy transformation?

+1 vote
1,047 views
How to update the target table without using update strategy transformation?
posted Jul 18, 2013 by anonymous

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

2 Answers

+1 vote

We can update all rows by setting Treat rows as update in properties tab of session task.
More details can be found on update without update strategy in informatica

answer Mar 26, 2016 by anonymous
0 votes

In the session properties, there is an option 'Treat Source Rows As'. Using this option you can specify whether all the source rows need to be inserted, updated or deleted.

answer Jul 18, 2013 by Shatark Bajpai
Similar Questions
+2 votes

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

+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 ?

...