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
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is xml source qualifier transformation in informatica?
What is an expression transformation?
Which transformation should we use to normalise the COBOL and relational sources?
How is union transformation utilized?
waht type of interface is used for testing the data in informatica
What are session parameters ? How do you set them?
expain about the tune parameters?
Define mapplet?
What does cheating measurement mean?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What do you understand by SOA of Informatica?
What are the different types of repositories created using informatica?
What is an aggregator transformation?
what is INFORMATICA TESTING process