Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Can we insert ,update ,delete in target tables with one
update strategy tran.?

Answers were Sorted based on User's Feedback



Can we insert ,update ,delete in target tables with one update strategy tran.?..

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

Can we insert ,update ,delete in target tables with one update strategy tran.?..

Answer / sehaj

WE CAN UPDATE INSERT ROWS INTO TARGET TABLE USING SAME
UPDATE STRATERGY IN A SESSION BUT WE NEED TO SELECT THE
OPTION UPDATE ELSE INSERT OPTION FROM SESSION
PROPERTIES>MAPPING.
BUT WE CAN INSERT UPDATE N DELETE,I MEAN PERFORM ALL THREE
AT A TIME.

Is This Answer Correct ?    2 Yes 6 No

Post New Answer

More Informatica Interview Questions

What is a snowflake schema?

0 Answers  


how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,


If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,


How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,


wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,


Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,


Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,


Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,


What is the use of an aggregator cache file?

0 Answers  


when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  


What is Code Page Compatibility?

1 Answers  


Repository user profiles

0 Answers  


Categories