F.17 Insurance - Summary Datamaps

Summary Datamaps are used to calculate aggregations across various entities using Trade, Transaction, Positions and Balances tables.

These datamaps populate various profile tables for different entities such as Account Profile, Household Profile, Correspondent Bank Profile, the aggregation is done either daily, weekly or monthly depending on the business areas. The following table describes the Summary datamaps for Insurance.

Note:

To execute the datamap WatchListStagingTable_WatchListInstnIDUpd against 1.5 million records, the tempspace should be set to 400GB or above.

Table F-17 Insurance - Summary Datamaps

Datamap Number	Datamap Name	Predecessors
40110	InsurancePolicyDailyProfile_InsTrxnInsPolicyBal	NA
40120	InsurancePolicyProfile_InsurancePolicyDailyProfile	40110
11300	AccountChangeLogSummary	The datamap should be executed once the change log processing is done.
11310	AccountToCustomerChangeLogSummary	The datamap should be executed once the change log processing is done.
11320	CustomerChangeLogSummary	The datamap should be executed once the change log processing is done.

Note:

The AccountChangeLogSummary, AccountToCustomerChangeLogSummary, and CustomerChangeLogSummary datamaps must be run with execute.sh from 8.0.2 onwards.