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 the difference between informatica6.1 and infomatica7.1
Define the various join types of joiner transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
State the differences between sql override and lookup override?
On which transformations you created partitions in your project?
How do you change a non-reusable transformation to reusable transformation?
What is workflow manager?
permutations of mapplet
How can you generate reports in informatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What do you mean by enterprise data warehousing?
What is a standalone command task?
Explain what transformation and how many are there in informatica?
Where are the source flat files kept before running the session?
How can informatica be used for an organization?