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 song in infrmatica...?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the use of source qualifier?
How do you migrate data from one environment to another?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain sessions. Explain how batches are used to combine executions?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Separate from an archive server and a powerhouse?
What is an active transformation?
what is the difference between informatica6.1 and infomatica7.1
What is Cognos script editor?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is the sql query overwrite in source qualifier in informatica
permutations of mapplet
How to do unit testing in informatica?