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
list out all the transformations which use cache?
Why do you use Mapping Parameter and mapping variable?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is a dimensional model?
COM components can be used in Informatica
If informatica has its scheduler why using third party scheduler?
What is union transformation?
What is target designer and target load order?
What is Index Caches size?
What are the new features of informatica 9.x in developer level?
What is the Process to creating lookup transformation in informatica
How can we store previous session logs?
Define sessions in informatica etl?
what is the size of u r source(like file or table)?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?