0 Replies Latest reply on Sep 10, 2019 5:40 AM by Amit Bhartiya

    Passing reference table name in the parameter in Informatica Developer

    Amit Bhartiya Active Member

      I have a reference table ABC_REF which contains certain database name. Now, I want to take that reference table in a parameter and check for that value in an expression transformation.

       

      I am passed the reference table name ABC_REF in the default value while defining the parameter( DE_VALUES). Is that fine?

       

       

      Also, below is the condition in my expression transformation:

      IIF(HC_Y_N_='N' AND IN(Data_Element,$DE_Values), 'Fail','Pass')

       

      But this only giving me pass condition even though failed one exist.

       

      Can anyone please suggest how to achieve that?