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

Which will beter perform IIf or decode?

Answer Posted / venkat

decode is better perform than iff condtion,decode can be
uesd insted of using multiple iff cases

Is This Answer Correct ?    26 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to update a particular record in target with out running whole workflow?

1533


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7266


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

1986


What do you mean incremental aggregation?

1010


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2677


How can you define user defied event?

975


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1997


explain abt ur project architecture?

2122


What are the settings that you use to configure the joiner transformation?

1000


What is rank transform?

941


Define joiner transformation?

986


What are the restrictions of union transformation?

976


Explain incremental aggregation in informatica

1064


What is joiner change?

1078


What is a mapplet/worklet in informatica?

1120