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
Implementation methodology
What is a pre-defined event and user-defined event?
Write the prerequisite tasks to achieve the session partition?
Enlist few areas or real-time situations where informatica is required.
Can we get 1st record through Informatica(without sequence number).
What's the layout of parameter file (what does a parameter file contain?)?
What are the types of data warehouses?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is update strategy transform?
which one is better performance wise joiner or look up
How can you increase the performance in joiner transformation?
Explain lookup transformation is active in informatica
Explain sessions. Explain how batches are used to combine executions?
Explain how many types of dimensions are available in informatica?