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


Please Help Members By Posting Answers For Below Questions

Implementation methodology

1486


What is a pre-defined event and user-defined event?

776


Write the prerequisite tasks to achieve the session partition?

849


Enlist few areas or real-time situations where informatica is required.

825


Can we get 1st record through Informatica(without sequence number).

1214


What's the layout of parameter file (what does a parameter file contain?)?

2181


What are the types of data warehouses?

1180


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1761


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1666


What is update strategy transform?

808


which one is better performance wise joiner or look up

851


How can you increase the performance in joiner transformation?

938


Explain lookup transformation is active in informatica

864


Explain sessions. Explain how batches are used to combine executions?

794


Explain how many types of dimensions are available in informatica?

782