Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

294 Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

Incremental update of CIIS objects

Update of the CIIS objects have to occur when:

򐂰 Certain changes occur to the operational systems that need to be reflected in

CIIS.

򐂰 Results of analysis and mining of the data warehouse requires the status of a

customer to be updated in the CIIS.

In our DFC Customer Insight solution, we chose to directly update the customer

status field in the underlying DB2 table of the CIIS based on analysis of the data

warehouse. The assumption is that the changes have been captured and loaded

onto a separate table. We used Ascential DataStage to perform this update as

shown in Figure C-22 through Figure C-26 on page 298. Since this update only

affects a single table in the CIIS, there are no consistency concerns of directly

updating the underlying DB2 table.

Figure C-22 Incremental update of CIIS

Appendix C. Data models, table/file definitions, et al used in the DFC Customer Insight business solution

Figure C-23 Update CIIS Extract Stage

296 Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

Figure C-24 Update CIIS Transform Stage

Appendix C. Data models, table/file definitions, et al used in the DFC Customer Insight business solution

Figure C-25 Update CIIS Load Stage - Update existing rows only

Note the Update action for the load as being Update existing rows only in

Figure C-25.

298 Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

Figure C-26 Update CIIS Load Stage