without dynamic lookup how to insert new rows and update
existing rows?



without dynamic lookup how to insert new rows and update existing rows?..

Answer / venubyna1

using Update strategy

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More Informatica Interview Questions

what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,


two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,


i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,


Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

15 Answers   TCS,


what is confirmed dimension?

6 Answers  






Is it possible to create multiple domains on a single Informatica server?

0 Answers  


Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,


Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,


tell me the rules and responsblites in our project(my project is development)

0 Answers  


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,


What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  


What are the tasks that Loadmanger process will do?

1 Answers  


Categories