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

hi real timers . iam waiting for ur reply regarding ETL TESTING

1803


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1744


What are the performance considerations when working with aggregator transformation?

674


Where do we use mapping variables in informatica?

613


Can you generate sequence numbers without using the sequence generator transformation?

597






Did u used latest transformations of 8.6.0? for what?

1474


In warehouses how many schemas are there?

582


How can we remove the duplicates from flat file source?

574


What is an unconnected transformation?

660


What is data transformation manager process?

619


How can you validate all mappings in the repository simultaneously?

753


According to his methodology what all you need before you build a datawarehouse

1183


What are the transformations that are not supported in mapplet?

593


How many input parameters can exist in an unconnected lookup?

989


What are the different types of transformation available in informatica.

634