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
How do you convert single row from source into three rows into target?
What is a pre-defined event and user-defined event?
State the limitations where we cannot use joiner in the mapping pipeline?
can anyone explain me about retail domain project in informatica?
What is powercenter on grid?
What are multi-group transformations?
What is mapplet in informatica?
what is the size of your data warehousing?
Quickly characterize reusable change?
What is parallel processing in informatica?
How to load data in informatica ?
What is Cognos script editor?
What does refresh system mean, and what are its distinctive choice?
What are the differences between joiner transformation and source qualifier transformation?
What are the advantages of informatica?