4.15.2 Loading Data into the Customer Tables (Delta Load)

The delta load allows you to move only the changed or enhanced data from the staging table to the business table.

If any customer data is changed in stage data only those data is moved in business. Based upon the date you run the batch.

For example, if any new entry has come for the same customer ID on a different date. Only those customer details are pushed to the business table.

The following workflow explains the external entity data movement from stage tables to business tables.

Figure 4-29 Delta Load Workflow

To load data into the Customer tables, follow these steps:

1. Log on to the Customer Screening application.
2. Click Common Tasks, then click Rule Run Framework, and then click Run.
   The Run page is displayed.

   Figure 4-30 Run page

   
   

   

   
   
3. In the Run page, select the CSBusinessDataLoad checkbox and click Edit.
   The Run page is displayed in edit mode.

   Figure 4-31 Run Definition page (Edit mode)

   
   

   

   
   
4. Click Selector and then select Job.
   The Component Selector window is displayed.
5. Select the Truncate_Tables task and then click drop-down list.

   Figure 4-32 Component Selector Window

   
   

   

   
   
6. Change the parameter value to N and click OK to close the Parameters window.

   Figure 4-33 Parameters window

   
   

   

   
   

   Note:

   By default it is “Y”, if delta mode to be supported, update from “Y” to “D”.
7. Click OK to close the Component Selector window.
8. Click Next.
9. Click Save.