Extracting data driven by a values in a hash file?
Posted: Tue Nov 09, 2004 10:35 pm
I have the following job structure.
HASH FILE
|
| DsLink1
|
TRANSFORMER --------->>> Hash File
^
|
|DSLink2
|
|
ODBC
I just want to be able to extract data from the ODBC stage using a query similar to
SELECT * from ODBC_Table
where OT_ITCGY = '1'AND
OT_ITEM <= DSLink1.UpperLimit AND
OT_ITEM >= DSLink1.LowerLimit;
The ODBC stage and the HashFile Stage doesn't share a common key.
Eventually I can eliminate the HashFile stage and hard code the join myself in ODBC stage itself, but what's the fun of doing that?
I hope the question is clear enough..
Thanks.
[/img][/list]
HASH FILE
|
| DsLink1
|
TRANSFORMER --------->>> Hash File
^
|
|DSLink2
|
|
ODBC
I just want to be able to extract data from the ODBC stage using a query similar to
SELECT * from ODBC_Table
where OT_ITCGY = '1'AND
OT_ITEM <= DSLink1.UpperLimit AND
OT_ITEM >= DSLink1.LowerLimit;
The ODBC stage and the HashFile Stage doesn't share a common key.
Eventually I can eliminate the HashFile stage and hard code the join myself in ODBC stage itself, but what's the fun of doing that?
![Smile :)](./images/smilies/icon_smile.gif)
I hope the question is clear enough..
Thanks.
[/img][/list]