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

where to store informatica rejected data?

766


What are the basic requirements to join two sources in a source qualifier transformation using default join?

697


What are the main features of Oracle 8i with context to datawarehouse?

1769


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

744


 Informatica Checkpoints

2944






Can anyone tell me the new features in Informatica 9 Version?

1620


What is informatica etl tool?

644


Enterprise data warehouse your projects phase by phase explain?

1562


Explain about cumulative Sum or moving sum?

703


While importing the relational source definition from the database, what are the metadata of source that will be imported?

909


what is informatica metadata?

692


Differentiate between sessions and batches?

658


What are the differences between source qualifier and joiner transformation?

682


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

817


How to extract the informatica rejected data?

847