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

What is difference between a gateway node and worker node?

630


What is rank transform?

603


What is joiner change?

683


What are the modules in Power Center

1240


What is Session and Batches?

666






what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1700


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

606


How many dimensions are there in informatica?

630


What is rank transformation?

581


what is diff b/t sorter t/r and agg have the option sorter property...

1748


What is the meaning of up gradation of repository?

1391


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

629


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

630


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

1812


Explain in detail scd type 2 through mapping.

619