without update strategy how to insert &update?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1697


Differences between connected and unconnected lookup?

610


What is a joiner transformation and why it is an active one?

580


What is persistent lookup cache?

605


What is lookup change?

624






What is a predefined event?

662


What is informatica?

686


How an expression transformation differs from aggregator transformation?

628


How you prepared reports for OLAP?

1156


What happens when a session fails and you click on recover?

660


server hot-ws270 is connect to Repository B. What does it mean?

1859


What are the designer tools for creating transformations?

687


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1861


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

600


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

601