Can we insert ,update ,delete in target tables with one
update strategy tran.?
Answer Posted / manojkumar
Yes we can do all these insert,update,delete also reject by
using single update strategy.
In update strategy write the code like this
iif(somexvalue=xx,dd_insert,iif(somexvalue=yy,dd_update,iif
(somexvalue=zz,dd_delete,dd_reject)))
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
What does refresh system mean, and what are its distinctive choice?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Define update strategy?
What is rank transformation?
what is mean by complex business rule ?
What is the need of etl tools?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How to extract sap data using informatica? What is abap? What are idocs?
tell me the rules and responsblites in our project(my project is development)
What are the components of Informatica? And what is the purpose of each?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the different options available for update strategy?
What does “tail –f” command do and what is its use as an Informatica admin.
What are the differences between source qualifier and joiner transformation?
What can we do to improve the performance of informatica aggregator transformation?