same hash file used for multiple lookup in 1 transform
Posted: 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?
Thanks.
Jen
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 ----->
Jen