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

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1736


What is the benefit of session partitioning?

849


What is blocking transformation?

929


How to generate sequence numbers?

843


Differentiate between a repository server and a powerhouse?

816


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2526


Briefly explain the aggregator transformation?

801


Different sorts of metadata that stores in the storage facility?

801


Explain pushdown optimization and types in informatica

879


Explain how to import oracle sequence into informatica?

801


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1852


What are the mapping parameters and mapping variables?

852


How can you increase the performance in joiner transformation?

946


Explain the scenario which compels informatica server to reject files?

934


Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

7233