2. Manage a CFI Loader

2.1. Add a CFI Loader

Use API_CFIADM.ADD_LOADER to add a new loader. The loader name is unique and the TSA retention parameter specifies the number of days data should remain in a TSA table before being removed. The priority is an integer between 0 and 99. A higher value means higher priority during TSA load. If the ultimo shift is set to true the BDate for a business ultimo day will be shifted to the calendar ultimo.

Example

EXECUTE SCRIPT API_CFIADM.ADD_LOADER(
   'PERSON'   -- p_ldr_name
   ,null      -- p_tsa_retention
   ,99        -- p_priority
   ,true      -- p_use_ultimo_shift
);

Issuing this command results in a new entry in the table CFIADM.CFI_LOADER.

LDR_NAME	TSA_RETENTION	PRIORITY	USE_ULTIMO_SHIFT
PERSON	null	99	true

2.2. Modify a CFI Loader

Modify a loader with API_CFIADM.MODIFY_LOADER. The loader name itself cannot be changed but all other parameters. Providing NULL leaves the parameters as is, while a blank (’ ‘) restores the default value. The following example shows such a modification. In this case the retention period will be changed and ultimo shift deactivated, while the priority stays the same.

Example

EXECUTE SCRIPT API_CFIADM.MODIFY_LOADER(
   'PERSON'   -- p_ldr_name
   ,3         -- p_tsa_retention
   ,null      -- p_priority
   ,false     -- p_use_ultimo_shift
);

After running the command above the entry for the loader ‘PERSON’ in the table CFIADM.CFI_LOADER will have changed as can be seen below.

ldr_name	tsa_retention	priority	use_ultimo_shift
PERSON	3	99	false

2.3. Remove CFI Loader

To remove a CFI loader just provide the name of the loader that should be removed to the script API_CFIADM.REMOVE_LOADER:

Example

EXECUTE SCRIPT API_CFIADM.REMOVE_LOADER(
   'PERSON'   -- p_ldr_name
);

After issuing the command above the entry belonging to the loader ‘PERSON’ will have been removed from the table CFIADM.CFI_LOADER.