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