2 Replies Latest reply on Sep 5, 2019 3:10 PM by Tejaswi G

    Passing Multiple Values for Entity Criteria Parameter

    Abhinav Bhatnagar Active Member

      Hi,

       

      In Informatica TDM I have created an entity and using criteria parameter to filter the records. Parameter file is created and I have multiple values for this criteria parameter. Below is my  parameter file

      [GLOBAL]

      $$DEPTNO=00004,023011,180002

      Criteria parameter $$DEPTNO is created in TDM with data type as numeric ,default value zero, override yes.

       

      I created a plan which uses  the entity and generated the workflow. I get below  error message when I ran the workflow "

       

      [VAR_27056 Data conversion error in converting[00004,023011,180002],

       

      When ran the workflow using single value for $$DEPTNO (ie $$DEPTNO=00004 in the parameter file) it ran successfully.

       

      Can't we pass multiple values for a criteria parameters in parameter file? Am I using correct method to pass multiple values?

      Any alternate solution if it can't be?

       

      Informatica TDM version is 10.2.0 HF1

       

      Thanks,

      Abhinav