Page 1 of 1
teradata connector stage
Posted: Tue Dec 14, 2010 7:00 am
by iskapalli
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.
Posted: Tue Dec 14, 2010 1:53 pm
by ray.wurlod
Sparse lookup is not supported for Teradata Connector, as far as I am aware.
Posted: Tue Dec 14, 2010 10:48 pm
by iskapalli
thanks for your reply.
But I am useing normal lookup
Posted: Wed Dec 15, 2010 3:19 am
by ray.wurlod
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.
Posted: Wed Dec 15, 2010 5:35 am
by iskapalli
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?