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
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
What is lookup transformation?
Is there any target staging area in informatica not staging area
What are the modules in Power Center
Enlist the tasks for which source qualifier transformation is used.
Explain lookup transformation source types in informatica
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How do you load unique records into one target table and duplicate records into a different target table?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
how we can load rejected record's at run time?(not through bad files)
explain abt ur project architecture?
What are the new features of informatica 9.x at the developer level?
what is SDLC way of code development?
What do you understand by SOA of Informatica?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.