without update strategy how to insert &update?



without update strategy how to insert &update?..

Answer / nivas

First you create the mapping according to your requirement
after that you create session.

Double click the session and then select properties tab in
the properties tab choose Target Rows Source as what do you
want (Insert, update,delete, Datadriven(this is only when
your using update stratogy transformation in the mapping)).

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is update strategy transform?

0 Answers  


What are the tasks that source qualifier performs?

1 Answers  


I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,


What is an expression transformation?

0 Answers  






What are the different tools in workflow manager?

1 Answers  


How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

0 Answers  


How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  


What is the Difference between DSS & OLTP?

5 Answers  


what is incremantal aggregation?

1 Answers  


Define sessions in informatica etl?

0 Answers  


Categories