Supplemental Information for Delta Load

If your implementation uses Delta load to seed data, there are specific considerations when maintaining your data.

When certain tables are updated, you must maintain the corresponding seeding table entries. Similarly, when seeding tables are updated, you must maintain the corresponding primary table entries. The following table provides the tables which require data maintenance when the corresponding tables are updated.

Table 2-4 Tables Requiring Maintenance when Delta Loading

Primary Table Seeding Table
STG_LOAN_CONTRACTS STG_ACCOUNT_ALT_CCY_VALUES
STG_LIFE_INS_CONTRACTS STG_ACCOUNT_ALT_CCY_VALUES
STG_PHONE_MASTER
  • STG_ACCOUNT_PHONE_MAP
  • STG_PARTY_PHONE_MAP
STG_ADDRESS_MASTER
  • STG_ACCOUNT_ADDRESS_MAP
  • STG_PARTY_ADDRESS_MAP
STG_EMAIL_MASTER
  • STG_ACCOUNT_EMAIL_MAP
  • STG_PARTY_EMAIL_MAP