Orchestrate Column doesnt pass in reference query

[NShah]

Hi,
I have two source. 1 is oracle table with three columns (GRGR_ID,PRPR_ID,GRGR_SELL_OVER_DT).
Another one is sybase table. I have to fetch member under the group (GRGR_ID)coming from oracle. I used orchestrate using sparse lookup.
The query is like this :
GRGR.GRGR_ID= ORCHESTRATE.GRGR_ID And
(ORCHESTRATE.GRGR_SELL_OVER_DT >= convert(char(10),MEPE.MEPE_EFF_DT,101) as MEPE_EFF_DT

But while running the job it is showing error like:
Error in prep stmt: SELECT----
GRGR.GRGR_ID= ? And
( ? >= convert(char(10),MEPE.MEPE_EFF_DT,101)

I have taken both source and reference column with same name
So here orchestrate value doesnt pass. So please provide any solution.

Nishant Shah

[ArndW]

Are both GRGR_ID and GRGR_SELL_OVER_DT marked as key columns in the reference link?

[NShah]

Are both GRGR_ID and GRGR_SELL_OVER_DT marked as key columns in the reference link? ...

-----------------
Not marked. But should I make it key column?
GRGR_ID and GRGR_SELL_OVER_DT is coming from source oracle table and reference is sybase table. Here in sybase I have 4 to 5 tables which each has different dates and meber under the groups which come from source Oracle. So I have to capture those members which are under the groups and GRGR_SELL_OVER_DT is fall between effective dates of member.
May I use Orchestrate to fire query itself in Sybase with GRGR_ID and SELL_OVER_DT coming from oracle? OR is there any way to capture those members directly from Sybase who met the condition with source GRGR_ID and Sell_Over_Date? Appriciate your help.

[chulett]

I think it's safe to imply from the question that yes, they should be so marked.