Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

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

Figure C-18 DataStage Designer Credit Transactions Transformer Stage

Figure C-18 describes the Transformer Stage, which includes the mapping

between the source columns (TRANSFORM link) and the target columns (LOAD

link), and any transformations to be performed.

Incremental update of the data warehouse

The Ascential DataStage jobs for incrementally updating the data warehouse on

a recurring basis are quite similar to the processes described in “Initial load of the

data warehouse” on page 266 except for the following differences:

1. The Update action field in Figure C-13 on page 270 should be Insert new or

update existing rows.

2. The data sources are different because they need to

only have access to

changed data, that is, incremental changes that have occurred since the last

update.

Note: Similar jobs can be defined for the other transaction summaries.