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 / james

Decode function has better performance than IIF function,
bcoz for multiple conditions we have to use nested queries
when u r going with IIF whereas with Decode u don't have to
write nested queries.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain your project of banking domian.

1652


What are the different ways to implement parallel processing in informatica?

1423


wat are deployement groups in informatica, how it will be used for developers

1719


Can we change Dynamic to Static or Persistent cache? If so what happens?

2210


What are Dimensional table?

1055


What is the session task and command task?

1058


What is a node in Informatica?

1041


explan ur project architecture?

2069


What do think which one is the better joiner or look up?

1203


Explain what are the different versions of informatica?

1097


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1906


Name the different lookup cache(s)?

1234


Which development components of informatica have the highest usage?

1043


How many ways are there to do 'remove duplicate records in informatica'?

1014


update strategy transformation in informatica

1064