17.5 Multiple Execution of T2Ts using the Runchart

Use the Process ID FSDF_SOURCED_RUN to populate data in the FSI_EXCHANGE_RATES table with the Run SKey defaulted to -1.

Note:

Use these exchange rates to populate data in the FSDF Result tables that do not contain any Run SKey.

Use the FSDF Source Run to populate the previously mentioned Results tables (that use the exchange rates), which were populated against the Run SKey -1.

The T2T is also a part of the seeded Financial Services Data Foundation Execution Run. When executing the Run, the Run SKey is auto-generated and stamped against each record. The FSDF Result tables with valid Run SKey in their Primary Key are a part of this Run. The exchange rates populated against each Run SKey are used to populate the Results Area of the same Run SKey.

Note:

The Exchange Rates T2Ts are a part of the Run Chart twice:

The first is through a batch. This inserts the Run SKey as -1 in the Exchange Rates table.

The second is through a Run. This inserts the Run SKey as an actual Run SKey in the Exchange Rates table.

For example, the FCT_COMMON_ACCOUNT_SUMMARY table is not a Run enabled table. Therefore, the join is with -1. However, the FCT_REG_ACCOUNT_SUMMARY table is a Run enabled table. Therefore, the join is with the actual Run SKey.

All the T2Ts that are a part of the Process ID FSDF_EXE_RUN, use the exchange rates with the actual Run SKey, and the other T2Ts use the Run SKey -1.