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
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Differentiate between a repository server and a powerhouse?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Explain the different kinds of facts.
What is the difference between a connected look up and unconnected lookup?
How to open an older version of an object in the workspace?
How to call shell scripts from informatica?
What is status code in informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Explain what are the different types of transformation available in informatica.
How can you increase the performance in joiner transformation?
What is the function of look up transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
What is Cognos script editor?
What is the cumulative sum and moving sum?