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
- 14682 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Why update strategy and union transformations are active? Explain with examples.
what are the deliverables?in your project?
What is the need of an ETL tool?
Explain transaction control transformation in informatica
What is meant by target load plan?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Briefly explain the aggregator transformation?
can anyone suggest best free Talend data integration training online
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
how tokens will generate?
Differences between connected and unconnected lookup?
Have you worked with/created Parameter file
What is a predefined event?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How can you validate all mappings in the repository simultaneously?
