How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
Answers were Sorted based on User's Feedback
Answer / sudhar
Use the session properties,
In Target Properties use options
Insert
update else Insert
Check boxes.
Is This Answer Correct ? | 15 Yes | 1 No |
Answer / abhinav
By using an UPDATE STARTEGY transformation.
DD_UPDATE = If the record alreadye exists
DD_INSERT = If the record is a new one
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / sailu
Do look up on the target with the key values. Check if the
look up is null or not. If look up value is null insert it
and if look up value is not null update it using update
strategy transformation with DD_UPDATE
Is This Answer Correct ? | 1 Yes | 0 No |
Hi Sudhar,
Please check your answer it is not working....
We can use the SCD type 1 only get the new row as insert
into target and updated record as update into target.
If it wrong means please mail me.. chandranmca2007@gmail.co
Is This Answer Correct ? | 0 Yes | 0 No |
What is difference between a connected look up and unconnected look up?
Can we insert and update a target table without using update strategy transformation?How?
In which circumstances that informatica server creates Reject files?
Why we need XMLs?
How the informatica server sorts the string values in Rank transformation?
how can you load data into target table without leading zeor's
what is the difference between onsite & client site?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
wht target override?wht advantages it has compare to target update?
why union transformation is active transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.