Which will beter perform IIf or decode?

Answer Posted / abhishek guddu

DECODE FUNCTION YOU CAN FIND IN SQL BUT IIF FUNCTION IS NOT
IN SQL. DECODE FUNCTION WILL GIVE CLEAR READABILITY TO
UNDERSTAND THE LOGIC TO OTHER.

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many types of dimensions are available in informatica?

565


What is the use of transformation?

576


What is meant by pre and post session shell command?

628


list out all the transformations which use cache?

691


What are some examples of informatica etl programs?

540






Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1861


What is pmcmd command?

677


how tokens will generate?

1738


What is dynamic cache?

614


what is the difference between informatica6.1 and infomatica7.1

1719


What are the differences between joiner transformation and source qualifier transformation?

628


How to join three sources using joiner? Explain though mapping flow.

702


What is a joiner transformation and why it is an active one?

580


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1338


How do you load unique records into one target table and duplicate records into a different target table?

712