5.10.6 Re-Load Of Transaction Summary Data

T2T component can only perform Insert operations. In case user needs to perform updates, previously loaded records should be deleted before loading the current records.

Function fn_deleteFusionTables is used for deleting the records in the target that are present in the source. This function removes rows in the table if there are matching rows in the Stage table. This function needs FSI_DELETE_TABLES_SETUP to be configured. Configure the following table for all columns that need to be part of the join between Stage table and Equivalent table.

Create a new Batch with the Task and specify the following parameters for the task to delete existing records:

• Datastore Type: Select appropriate datastore from the drop down list.
• Datastore Name: Select appropriate name from the list. Generally it is the Infodom name.
• IP address: Select the IP address from the list.
• Rule Name: fn_deleteFusionTables
• Parameter List: 'Table to be deleted'

Batch Run ID and As Of Date are passed internally by the batch to the Data Transformation task.

Sample record for FSI_DELETE_TABLES_SETUP table is given following:

Table 5-9 Sample record for FSI_DELETE_TABLES_SETUP table

Column Name	Column Description	Sample Value
STAGE_TABLE_NAME	Stores the source table name for forming the join statement	STG_LOAN_CONTRACTS
STAGE_COLUMN_NAME	Stores the source column name for forming the join statement	V_ACCOUNT_NUMBER
FUSION_TABLE_NAME	Stores the target table name for forming the join statement	FSI_D_LOAN_CONTRACTS
FUSION_COLUMN_NAME	Stores the target column name for forming the join statement	ACCOUNT_NUMBER

Note:

Insert rows in FSI_DELETE_TABLES_SETUP for all columns that can be used to join the stage with the equivalent table. In case if the join requires other dimension or code tables, a view can be created joining the source table with the respective code tables and that view can be part of the above setup table.