same hash file used for multiple lookup in 1 transform

JNG · Post by **JNG** » Mon Oct 18, 2004 1:36 pm

Hi,

Is it possible to perform lookup against the same hash file using multiple input columns within a single transform?

I have a sequential file input with 2 amount fields and 2 different currency codes, and need to perform currency conversion. The hash file has the currency code, and the conversion rate. For amount A, I need to use currency code C1, and for amount B, I need to use currency code C2. If any of the currency code lookup fails, I need to use 'USD' as the default currency conversion.

Can I have 3 reference links from the same hash file, going into the same transform, like the following?

Code: Select all

    _______________ 
   | currency code | ---crncy1lkup -->
   | hash file     | ---crncy2lkup -->  TRANSFORM
   |_______________| ---USDlkup ----->

Thanks.
Jen

KeithM · Post by **KeithM** » Mon Oct 18, 2004 1:45 pm

Yes you can lookup to the same hash file multiple times in the same transformation. You just need to have three links from the hash file to the transformation so that you can define each link. You will also have to define the output three times in the hash stage for each of the output links.

JNG · Post by **JNG** » Mon Oct 18, 2004 1:50 pm

Thanks Keith. It's asking for the file name for each output link. I suppose I can specify the same file name in each case?

Thanks.
Jen