what is update strategy transformation ?
- 7 Answers
- 22108 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / geetha
Updatestartegy used to define Transaction control
Informatica default transaction Insert
Using updatestartegy we can define
(1) Dd_insert
(2) Dd_update
(3) Dd_delete
(4) Dd_reject
| Is This Answer Correct ? | 36 Yes | 9 No |
Answer / soujanya
used to perform dml operations such as insert update delete
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / swetha
This transformation is used to maintain the history data or
just most recent changes in to target table.
| Is This Answer Correct ? | 26 Yes | 18 No |
Answer / obulreddy.b
IT IS A TRANSFORMATION WHICH IS USED TO PERFORM DML
OPERATIONS ON ALREADY DATA POPULATED TARGETS.
GENERALLY INFORMATICA SERVER WILL TREAT SOURCE ROWS AS
INSERT. IF WE USE UPDATE STRATOGY TRANSFORMATION WE HAVE TO
SELECT TREAT SOURCE ROWS AS DATADRIVEN IN SESSION
PROPERTIES, NOW INFORMATICA SERVER DRIVES THE DATA AS PER
UPDATE STRATOGY VALUE.
WE HAVE TO SELECT UPDATE STRATOGY VALUE BASED ON OUR
REQUIREMENT.
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / usha
This Transformation is used to perform DML operation for
the already data populated target.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / saribalareddy
Whenever you create the target table whether you are store the historical data or current transaction data in to target table.
| Is This Answer Correct ? | 1 Yes | 2 No |
How do you promote a non-reusable transformation to reusable transformation?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
Whats the difference between $, $$, $$$
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
Explain the different lookup methods used in informatica?
my source is junk data how will u remove that junk data by using unix please any one replay me
Target is zero file and how can you send the email?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain your project of banking domian.
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
Teradata 
