Range Lookup
Posted: Wed Nov 21, 2007 11:22 pm
Dear All,
For range lookup,if I would like to use ODBC stage ,is it ok?
In our project ,we have some sonstraint of using UV stage .
My criteria is following:
There are 2 key fileds in REF table
SupplierCode
Accnt
in addition to that the following columns are there:
RunNBRStart
RunNBREND
LotNBR
In the source folloiwng columns are coming:
SupplierCode
Accnt
RunCaseNBR
IF source.SupplierCode=Ref.SupplierCode and
source.Accnt=Ref.Accnt
and ref.RunNBRStart<=source.RunCaseNBR AND ref.RunNBREND>=source.RunCaseNBR then pickup Ref.LotNBR.
Job Design:
ODBCLKP
SRC------>Tnsfr-------->Tgt
in Trnf stage I mapped source.SupplierCode=Ref.SupplierCode ,
source.Accnt=Ref.Accnt,source.RunCaseNBR=ref.RunNBRStart and
source.RunCaseNBR=source.RunNBREND
In the ODBC stage following query is used:
select LotNBR,RunNBRStart,RunNBREND,SupplierCode,Accnt from reftable
whre Ref.SupplierCode=? and Ref.Accnt=?and ref.RunNBRStart<=? AND ref.RunNBREND>=?
I have designed the above,but deu to unavailability of source data could not run and we donot have priviledge to create test data in DEV also.
Could you pls let me know if this is ok?
Many thanks for all your time.
Regards
For range lookup,if I would like to use ODBC stage ,is it ok?
In our project ,we have some sonstraint of using UV stage .
My criteria is following:
There are 2 key fileds in REF table
SupplierCode
Accnt
in addition to that the following columns are there:
RunNBRStart
RunNBREND
LotNBR
In the source folloiwng columns are coming:
SupplierCode
Accnt
RunCaseNBR
IF source.SupplierCode=Ref.SupplierCode and
source.Accnt=Ref.Accnt
and ref.RunNBRStart<=source.RunCaseNBR AND ref.RunNBREND>=source.RunCaseNBR then pickup Ref.LotNBR.
Job Design:
ODBCLKP
SRC------>Tnsfr-------->Tgt
in Trnf stage I mapped source.SupplierCode=Ref.SupplierCode ,
source.Accnt=Ref.Accnt,source.RunCaseNBR=ref.RunNBRStart and
source.RunCaseNBR=source.RunNBREND
In the ODBC stage following query is used:
select LotNBR,RunNBRStart,RunNBREND,SupplierCode,Accnt from reftable
whre Ref.SupplierCode=? and Ref.Accnt=?and ref.RunNBRStart<=? AND ref.RunNBREND>=?
I have designed the above,but deu to unavailability of source data could not run and we donot have priviledge to create test data in DEV also.
Could you pls let me know if this is ok?
Many thanks for all your time.
Regards