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
- 14843 Views
- Accenture, I also Faced
- E-Mail Answers
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
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are data-driven sessions?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What do think which one is the better joiner or look up?
Global and Local shortcuts. Advantages.
How to extract sap data using informatica?
To import the flat file definition into the designer where should the flat file be placed?
Differences between version 7.x and 8.x.
How do you manage the Parameter files while migrating your data from one environment to another environment?
without table how to come first record only in oracle?
What is a difference between complete, stop and abort?
What does command task mean?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
define galaxy repository in informatica
Explain pushdown optimization and types in informatica
