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

whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,


Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  


how to run the batch using pmcmd command

2 Answers   Wipro,


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,


What is rank transform?

0 Answers  






What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,


Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 Answers  


How can you access the remote source into your session?

1 Answers  


What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,


What could be the possible resons of locks by user?

0 Answers  


What are the types of lookup?

3 Answers   Wipro,


Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  


Categories