![Confused :?](./images/smilies/icon_confused.gif)
A file coming in through DataStage has one record coming in. The reference file has two records, which are stored in a hash file. We would like to have in the output two records. A left or right join in a query would work, but how can you do this in DataStage?
Example:
The file has:
zip_code, comp_cd, resp_cd, zipcount
00959, A, E, 1
The hash file has:
Zip_code, comp_cd, resp_cd, zipcount, RSID, ZIP_SPLIT_QTY, Perzipcount
00959, A, E, 1, 3G6D, 90, 0.9,
00959, A, E, 1, 3G6M, 10, 0.1,
Thanks!
Rodre
![Smile :)](./images/smilies/icon_smile.gif)