4.3.3.4 finalize.sh
Execute finalize.sh
script, to apply the
transformations to the data loaded into the Target SaaS environment.
finalize.sh
is located in
<$FIC_HOME>/utility/Data_Export_to_SaaS/bin
directory.
Syntax: ./finalize.sh <Start_Date
DDMMYYYY> <End_Date DDMMYYYY>
Note:
- The start date and end date are optional parameters.
- To transform the data for a specific time period, ensure to enter both the start and end date.
- If you provide only one date, it is considered as the start date.
- The
finalize.sh
script can be executed any number of times, but it is recommended to execute after all the data migration is complete.
Example: ./finalize.sh 01122023
31122023
Transformations Post Data Migration
finalize.sh
triggers the following data
transformations.
Table 4-3 Transformations post data migration
SaaS/Target Table | SaaS-Column | Transformations Post Data Migration |
---|---|---|
FSI_D_ASSET, FSI_D_LIABILITY, FSI_D_FEE_BASED_SERVICE, FSI_D_DERIVATIVE, FSI_D_LEDGER_INSTRUMENT, FSI_D_LOAN_COMMITMENTS, FSI_D_OFF_BALANCE_SHEET, FSI_D_ACCOUNT_RATE_TIERS, FSI_D_BREAK_FUNDING_CHARGES, FSI_D_PM_GENERATED_INSTRMTS | AMRT_TYPE_CD |
|
FSI_D_ASSET, FSI_D_LIABILITY, FSI_D_FEE_BASED_SERVICE, FSI_D_DERIVATIVE, FSI_D_LEDGER_INSTRUMENT, FSI_D_LOAN_COMMITMENTS, FSI_D_OFF_BALANCE_SHEET, FSI_D_ACCOUNT_RATE_TIERS, FSI_D_BREAK_FUNDING_CHARGES, FSI_D_PM_GENERATED_INSTRMTS | PMT_PATTERN_CD | If AMRT_TYPE_CD is between 1000 and 69999, the PMT_PATTERN_CD value is set to the AMRT_TYPE_CD value. In all other scenarios, it is set to NULL. |
FSI_D_ASSET, FSI_D_LIABILITY, FSI_D_FEE_BASED_SERVICE, FSI_D_DERIVATIVE, FSI_D_LEDGER_INSTRUMENT, FSI_D_LOAN_COMMITMENTS, FSI_D_OFF_BALANCE_SHEET, FSI_D_ACCOUNT_RATE_TIERS, FSI_D_BREAK_FUNDING_CHARGES, FSI_D_PM_GENERATED_INSTRMTS | BEHAVIOUR_PATTERN_CD | If AMRT_TYPE_CD is between 70000 and 99999, the BEHAVIOUR_PATTERN_CD is set to the AMRT_TYPE_CD value. Otherwise, it is set to NULL. |
FSI_D_ASSET, FSI_D_LIABILITY, FSI_D_FEE_BASED_SERVICE, FSI_D_DERIVATIVE, FSI_D_LEDGER_INSTRUMENT, FSI_D_LOAN_COMMITMENTS, FSI_D_OFF_BALANCE_SHEET, FSI_D_ACCOUNT_RATE_TIERS, FSI_D_BREAK_FUNDING_CHARGES, FSI_D_PM_GENERATED_INSTRMTS | ADJUSTABLE_TYPE_CD |
|
FSI_D_ASSET, FSI_D_LIABILITY, FSI_D_FEE_BASED_SERVICE, FSI_D_DERIVATIVE, FSI_D_LEDGER_INSTRUMENT, FSI_D_LOAN_COMMITMENTS, FSI_D_OFF_BALANCE_SHEET, FSI_D_ACCOUNT_RATE_TIERS, FSI_D_BREAK_FUNDING_CHARGES, FSI_D_PM_GENERATED_INSTRMTS | REPRICE_PATTERN_CD | If ADJUSTABLE_TYPE_CD is >= 500, then the REPRICE_PATTERN_CD is set to the ADJUSTABLE_TYPE_CD value. In all other cases, it is set to NULL. |
FSI_D_ASSET, FSI_D_LIABILITY, FSI_D_FEE_BASED_SERVICE, FSI_D_DERIVATIVE, FSI_D_LEDGER_INSTRUMENT, FSI_D_LOAN_COMMITMENTS, FSI_D_OFF_BALANCE_SHEET, FSI_D_ACCOUNT_RATE_TIERS, FSI_D_BREAK_FUNDING_CHARGES, FSI_D_PM_GENERATED_INSTRMTS | COMPOUNDING_BASIS_CD | If COMPOUNDING_BASIS_CD is either 200 or 999, the corresponding value is set to 160. Otherwise, the value of COMPOUNDING_BASIS_CD is retained. |
FSI_D_ASSET, FSI_D_LIABILITY | OPTION_EXPIRY_DATE | The OPTION_EXPIRY_DATE column in the target table is updated with the values from the OPTION_EXPIRY_DATE column in the FSI_D_EMBEDDED_OPTIONS_SCH table. |
FSI_D_ASSET, FSI_D_LIABILITY | STRIKE_VALUE | The STRIKE_VALUE column in the target table is updated with the values from the STRIKE_VALUE column in the FSI_D_EMBEDDED_OPTIONS_SCH table. |
FSI_D_ASSET, FSI_D_LIABILITY | STRIKE_IRC_CD | The STRIKE_IRC_CD column in the target table is updated with the values from the STRIKE_IRC_CD column in the FSI_D_EMBEDDED_OPTIONS table. |
FSI_D_ASSET, FSI_D_LIABILITY | EXERCISE_TYPE_CD | The EXERCISE_TYPE_CD column in the target table is updated with the values from the EXERCISE_TYPE_CD column in the FSI_D_EMBEDDED_OPTIONS table. |
FSI_D_ASSET, FSI_D_LIABILITY | RATE_LOOKUP_CD | The RATE_LOOKUP_CD column in the target table is updated with the values from the RATE_LOOKUP_CD column in the FSI_D_EMBEDDED_OPTIONS table. |
FSI_D_ASSET, FSI_D_LIABILITY | STRIKE_TYPE_CD | The STRIKE_TYPE_CD column in the target table is updated with the values from the STRIKE_TYPE_CD column in the FSI_D_EMBEDDED_OPTIONS table. |
FSI_D_ASSET, FSI_D_LIABILITY | OPTION_TYPE_CD | The OPTION_TYPE_CD column in the target table is updated with the values from the OPTION_TYPE_CD column in the FSI_D_EMBEDDED_OPTIONS table. |
FSI_D_ASSET, FSI_D_LIABILITY | OPTION_START_DATE | The OPTION_START_DATE column in the target table is updated with the values from the OPTION_START_DATE column in the FSI_D_EMBEDDED_OPTIONS table. |
FSI_D_ASSET, FSI_D_FEE_BASED_SERVICE, FSI_D_LEDGER_INSTRUMENT, FSI_D_LOAN_COMMITMENTS, FSI_D_OFF_BALANCE_SHEET |
ACCOUNT_TYPE | ACCOUNT_TYPE is searched
sequentially in the following tables and the value is
updated.
If ACCOUNT_TYPE is not present in any of the above mentioned tables, it is set to 100. |
FSI_D_LIABILITY | ACCOUNT_TYPE | ACCOUNT_TYPE is searched
sequentially in the following tables and the value is
updated.
If ACCOUNT_TYPE is not present in any of the above mentioned tables, it is set to 300. |
FSI_D_DERIVATIVE | ACCOUNT_TYPE | For the given LEG_TYPE
values, the following ACCOUNT_TYPE values
are configured.
|