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.