5.9.4 Re-Load Of Instrument 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.