Can we insert ,update ,delete in target tables with one
update strategy tran.?
Answers were Sorted based on User's Feedback
Answer / 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 |
What is a snowflake schema?
how to through logic of informatica using the push down optimization into oracle.
If I am having 6 flat files in data. How can you load the data at a time
How to generate a single mapping for both the historical and incremental load.
wht target override?wht advantages it has compare to target update?
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
Performance wise which is better joiner or look up ? Give me with example?
What is the use of an aggregator cache file?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
What is Code Page Compatibility?
Repository user profiles