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 EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is the benefit of session partitioning?
What is blocking transformation?
How to generate sequence numbers?
Differentiate between a repository server and a powerhouse?
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
Briefly explain the aggregator transformation?
Different sorts of metadata that stores in the storage facility?
Explain pushdown optimization and types in informatica
Explain how to import oracle sequence into informatica?
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
What are the mapping parameters and mapping variables?
How can you increase the performance in joiner transformation?
Explain the scenario which compels informatica server to reject files?
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