Answer Posted / jagadish
update strategy transformation is used to perform DML
operations for the already data populated targets.
by default informatica server will treat source row as
INSERT.if you use update strategy transformation in your
mapping the informatica server will treat source row as
DATA DRIVEN.so the datas transferd to a target that even
populated with some data can be inserted,updated,rejected
and deleted.based upon the functions like
dd_insert,dd_update,dd_reject,dd_delete you define in the
update strategy transformation.
| Is This Answer Correct ? | 41 Yes | 3 No |
Post New Answer View All Answers
What happens when a session fails and you click on recover?
What are the designer tools for creating transformations?
Can we get 1st record through Informatica(without sequence number).
How to create Target definition for flat files?
can we override a native sql query within informatica? How do we do it?
What is the benefit of partitioning a session?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is deployment group?
What do mean by local and global repository?
Enlist the advantages of informatica.
generate date / time dimension in informatica
What are the different transaction levels available in transaction control transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Is it possible to create multiple domains on a single Informatica server?