top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica Expression IIF

0 votes
273 views

I have this set of codes in my Informatica expression

IIF(V_TR = 'TT'
OR
V_TR = 'TV'
OR
V_TR = 'VC'
OR
V_TR = 'TI'
OR
V_TR = 'TL'
OR
V_TR = 'NC'
OR
V_TR = 'CE'
OR
V_TR = 'D1'
OR
V_TR = 'DM'
OR
V_TR = 'N1'
OR
V_TR = 'NA'
OR
V_TR= 'U1'
OR
V_TR = 'UA', 'Y', 'N')

I know what the code means but what exactly does it do in the expression? DOes it serve as a filter to filter out all these values?

posted Jun 20, 2014 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+1 vote

Without more context of what the expression and business needs of the expression it will be impossible to give more than guesses.

The 2 main ideas I can think of are:

The Y or N value are used later in a filter transform
The Y or N value is the desired output value based upon the input ports given the expression.

answer Jun 23, 2014 by Shweta Singh
0 votes

Filter the all records

answer Jun 23, 2014 by anonymous
Similar Questions
+2 votes

In unconnected lookup, what are the other transformations that can be used in place of that expression transformation?

+1 vote

I have a Column (SALARY) in Source Table from Relational DB, for example 15000 is a record in SALARY column and I want to format it as $15,000.00 into the Target table which is a Relational DB using Expression Transformation.

Thankyou

...