teradata connector stage

iskapalli · Post by **iskapalli** » Tue Dec 14, 2010 7:00 am

hi,
I have used teradata connnector as a lookup. I want to give the below used defined sql query in the SELECT clause.

pRUN_STRM_PROS_D=20100101

SELECT PRTY,MSGE_PRTY_C FROM MAP_CSE_MSGE_PRTY_BM WHERE CAST('#pRUN_STRM_PROS_D#' as date format 'yyyymmdd') BETWEEN EFFT_D (date, format 'yyyymmdd') AND EXPY_D (date, format 'yyyymmdd');

Please help me out.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 14, 2010 1:53 pm

Sparse lookup is not supported for Teradata Connector, as far as I am aware.

iskapalli · Post by **iskapalli** » Tue Dec 14, 2010 10:48 pm

thanks for your reply.
But I am useing normal lookup

ray.wurlod · Post by **ray.wurlod** » Wed Dec 15, 2010 3:19 am

I don't think what you're trying to do (BETWEEN) is possible - when you use a Lookup stage DataStage pre-loads the entire reference data set into memory and performs "=" (or range) comparisons against that.

iskapalli · Post by **iskapalli** » Wed Dec 15, 2010 5:35 am

i have given below query inside the teradata connector stage.

SELECT MAP_CSE_MSGE_PRTY_BM.PRTY,MAP_CSE_MSGE_PRTY_BM.MSGE_PRTY_C FROM
#pGDW_TECH_DB#.MAP_CSE_MSGE_PRTY_BM as MAP_CSE_MSGE_PRTY_BM
WHERE CAST('#pRUN_STRM_PROS_D#' as date format 'yyyymmdd')
BETWEEN MAP_CSE_MSGE_PRTY_BM.EFFT_D (date, format 'yyyymmdd') AND MAP_CSE_MSGE_PRTY_BM.EXPY_D (date, format 'yyyymmdd');

My jobs is running fine. I am getting the results what I expected.

But inside the stage it is showing below warning.

expecting : A conditon expression.

it is showing warning symbol. In the log there is no warning messages.

Can you please let me know why it is showing warning in the stage instead of datastage log. Is there any problem once code is moved to produciton?