Control Append KM, Group by clause
Ashok RNov 28 2012 — edited Nov 29 2012Hi 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?
Thanks,
Ashok