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
where to store informatica rejected data?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the main features of Oracle 8i with context to datawarehouse?
What happens when a session fails and you click on recover?
Informatica Checkpoints
Can anyone tell me the new features in Informatica 9 Version?
What is informatica etl tool?
Enterprise data warehouse your projects phase by phase explain?
Explain about cumulative Sum or moving sum?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
what is informatica metadata?
Differentiate between sessions and batches?
What are the differences between source qualifier and joiner transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How to extract the informatica rejected data?