Some help and advice on the following would be appreciated:
I have one job, I want to be able to output to multiple tables dynamically based on a value in a field. The target is AS/400 files (tables), all have the same metadata.
Example: Business Unit (BU) holds 8 distinct values, I want to output to 8 tables dynamically for each BU. A BU of 393 should be output to TABLENAME393, BU of 392 = TABLENAME392 etc
I want to avoid hardcoding by having 8 output links, with 8 constraints in the transformer. More BU's could be added in the future. So I would like this job to be generic with 1 output link.
I have looked into using multiple instance jobs, with an invocation ID for each BU, but this is still hardcoding.
![Confused :?](./images/smilies/icon_confused.gif)