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.

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

Answer / soujanya

used to perform dml operations such as insert update delete

Answer / swetha

This transformation is used to maintain the history data or
just most recent changes in to target table.

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.

Answer / usha

This Transformation is used to perform DML operation for
the already data populated target.

Answer / saribalareddy

Whenever you create the target table whether you are store the historical data or current transaction data in to target table.

When the informatica server marks that a batch is failed?

1 Answers  

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

permutations of mapplet

0 Answers   TCS,

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

Can we run session without using workflows?

5 Answers   TCS,

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

State the differences between sql override and lookup override?

0 Answers