Interested to Buy Any Domain ? << Click Here >> for more details...
How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
- 6 Answers
- 15086 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
Explain about the concept of mapping parameters and variables ?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is data caches/ index caches?
HOW TO DELETE A RECORD FROM FLAT FILE
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
what is the mechanism of the Master-Detail joining condition?
write a query to get maximum salary from the employers table without duplicates....kindly help me
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
Teradata 
