7 Replies Latest reply on Nov 29, 2012 12:39 PM by JeromeFr

    Control Append KM, Group by clause

    Ashok R
      Hi All,

      I am trying to use max function in interface (KM: IKM control append), in the mapping apart from the columns from source data store i am using few ODI variables (say LD_ID=200). Somehow LD_ID variable is being picked up by the KM in the group clause, because of this the job is failing with the error
      GROUP BY position 200 is not in target list. I understand the error but not sure why this variable is picked up in the grop by clause. The substituition method i see in the KM is odiRef.getGrpBy()

      Can someone please help me with this?