Decode function in etl informatica

Question

Decode(false,
ivar>10,'variable is greater than 10',
ivar<25, ' variable is less than 25 ',
'No match found ')

where ivar=25

What will be the answer as tha options are

..Greater than 10 ..Less than 25 ..No match found ..Error : expression is invalid

is this interview question? What do you think the answer should be? Just guess... — Koushik Roy, Aug 13 '21 at 05:48
According to me it should be greater than 10 but since both of them satisfies ,have a doubt — Sakshi Sharma, Aug 13 '21 at 07:08

score 0 · Answer 1 · answered Aug 15 '21 at 07:33

I think that the right answer is: variable is less than 25 because of:

Try to explain

First param is false - that means that we are waiting for the first false
first_search than first_result in params and last - default value that's why i check about the syntax and param numbers and it's ok. Than i'm watch on a value ivar=25
25 < 10 - true, but we need a false. 25 < 25 NO - that's what we are waiting for

If i'm mistaken tell me.

1 Answers1