How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
Answer Posted / sudhar
Use the session properties,
In Target Properties use options
Insert
update else Insert
Check boxes.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What is session task and command task?
What is intricate mapping?
Why is sorter an active transformation?
What is DR strategy for Informatica project?
How to convert multiple rows to single row (multiple columns) in informatica
How to create Target definition for flat files?
What are the modules in Power Center
How can we remove the duplicates from flat file source?
What are the tasks that can be performed using sq?
How to go to the older version for a mapping?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is the function of look up transformation?
expain about the tune parameters?
What is a stored procedure transformation?
What are different types of transformations available in informatica?