Which will beter perform IIf or decode?

Question Posted / sukanta

3 Answers
18616 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Which will beter perform IIf or decode?..

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

Which will beter perform IIf or decode?..

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

Which will beter perform IIf or decode?..

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

More Informatica Interview Questions

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers Wipro,

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers TCS,

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers

without table how to come first record only in oracle?

0 Answers

What are the components of Informatica? And what is the purpose of each?

0 Answers Informatica,

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers Emirates, IBM,

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers TCS, Tech Mahindra,

What is resilience time?

0 Answers

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers

What is the Difference between DSS & OLTP?

5 Answers

What is the procedure to load the fact table.Give in detail?

1 Answers

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers CSC,

For more Informatica Interview Questions Click Here