Interested to Buy Any Domain ? << Click Here >> for more details...
what is update strategy transformation ?
- 7 Answers
- 24207 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 |
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
What are the types of presistent cache in look up tr.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What happens if we dont select data driven option?
What is the difference between bitmap and btree index?
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
What is the difference between router and filter?
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
What is workflow? What are the components of workflow manager?
What is the target load order?
Define the various join types of joiner transformation?
Teradata 
