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
can we override a native sql query within informatica? How do we do it?
What is rank transformation?
What are the advantages of using informatica as an etl tool over teradata?
What are the restrictions of union transformation?
State the differences between sql override and lookup override?
What is pmcmd command?
what is the difference between informatica6.1 and infomatica7.1
Why sorter is an active transformation?
What is a filter transformation and why it is an active one?
What are the tasks that source qualifier perform?
What are the new features of informatica 9.x in developer level?
What is the format of informatica objects in a repository?
How to handle decimal places while importing a flatfile into informatica?
what is mean by complex business rule ?
How to generate sequence numbers without using the sequence generator transformation?