1.2.1.2 Maintaining Extraction Routines

You can maintain the data extraction routines in the maintenance table called ‘ESTM_TF_DEST_TABLES’. This table is used to maintain extraction routines and should be maintained manually with the following values along with other details:
Column Name Description
ORD_OF_EXT Order of extraction in which routine will be executed. This should be a unique value.
TABLE_NAME Name of the staging table to be populated with data.
ROUTINE Routine to be executed. The format should be ‘Package.procedure’
INTEGRATION_NAME OFSAA
All the parameters such as extraction date, previous extraction date, log required and so on are maintained in maintenance table ‘CSTB_TF_EIS_PARAM’. In this table the KEYID is the primary key.

Parent topic: Maintenances