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
Explain why we use partitioning the session in informatica?
Is stop and abort are same in informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is meant by LDAP users?
what is $$$$?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain in detail about scd type 1 through mapping.
How can we remove the duplicates from flat file source?
How will the document be delivered to me?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How does a rank transform differ from aggregator transform functions max and min?
What is rank transformation in informatica
How can we improve session performance in aggregator transformation?
What is dimensional table? Explain the different dimensions.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps