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 / 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 |
Post New Answer View All Answers
what is mean by complex business rule ?
What is a shortcut and copy in Informatica and how two are different with each other?
Define joiner transformation?
What is target load order?
What is the use of code page?
How might you approve all mappings in the archive all the while?
Performance tuning in UNIX for informatica mappings?
How can we store previous session logs?
where to store informatica rejected data?
What is intricate mapping?
Mention few advantages of router transformation over filter transformation.
Which version configuration tool used in ur project?
Which transformation should we use to normalise the COBOL and relational sources?
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?
What is a dimensional model?