Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Control Append KM, Group by clause

Ashok RNov 28 2012 — edited Nov 29 2012
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?

Thanks,
Ashok
This post has been answered by JeromeFr on Nov 28 2012
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 27 2012
Added on Nov 28 2012
7 comments
209 views