2 Replies Latest reply on Sep 25, 2019 2:08 AM by Amit Bhartiya

    Passing reference table name in the parameter in Informatica Developer

    Amit Bhartiya Guru

      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?