286 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
2. Issue and adjust the number of instances of each component in operation to
address the area experiencing a performance or data bottleneck.
– Create separate components for separate data sources.
For example, where source files with the same format arrive from
individual branches, process them separately using a different set of
staging tables. Where service level objectives require, you can process
the data in parallel.
– Separate processes to select ranges of data in same staging table.
Define multiple components that uniquely identify different ranges of data
and insert select in parallel.
For example, create two fact table data flow components that select ...