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.?

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


Please Help Members By Posting Answers For Below Questions

What does refresh system mean, and what are its distinctive choice?

1167


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1899


Define update strategy?

1214


What is rank transformation?

987


what is mean by complex business rule ?

2156


What is the need of etl tools?

1112


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8217


How to extract sap data using informatica? What is abap? What are idocs?

1176


tell me the rules and responsblites in our project(my project is development)

1931


What are the components of Informatica? And what is the purpose of each?

1050


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1119


What are the different options available for update strategy?

1000


What does “tail –f” command do and what is its use as an Informatica admin.

1099


What are the differences between source qualifier and joiner transformation?

1054


What can we do to improve the performance of informatica aggregator transformation?

1091