what is update strategy transformation ?
- 7 Answers
- 21484 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 |
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
What is persistent lookup cache?
Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek
what is the process of target load planing?
What does update strategy mean, and what are the different option of it?
hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
how to delete duplicate records by using filter transfermation?
we have to use order by,where,having we to implement sql query
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help
Tell me about MD5 functions in informatica
Teradata 
