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
- 14874 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
Under what condition selecting sorted input in aggregator may fail the session?
What is the benefit of session partitioning?
What differs when we choose the sorted input for aggregator transformation?
What is transformation?
How do you set a varible in incremental aggregation
Explain the mapping variable usage example in informatica
What is sorter transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Define update strategy?
What is a snowflake schema?
design of staging area?
Whats there in global repository
What is a connected transformation?
How can repository reports be accessed without sql or other transformations?
What is the function of aggregator transformation?
