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 is a node in Informatica?
Please let me know how to make encryption and decryption with example?
What is informatica metadata and where is it stored?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are the databases that informatica can connect to windows?
What is a pre-defined event and user-defined event?
What is an expression transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
differences between service based and product based?
Why update strategy and union transformations are active?
What are the advantages of informatica?
Explain the informatica workflow?
What are the components of Informatica? And what is the purpose of each?
What is main use of mapplet?
How is union transformation utilized?
