Tutorial: Creating Data and Process Flows With DataMigrator

Your company is trying to empower both its sales force and its line managers with timely and focused information to support needed decisions:

• Sales agents need information that will enable them to report quickly on the most and least popular products, and to track regional trends.
• Line managers need to assess strengths and weaknesses in their sales approaches using comparative analysis of competing stores to determine, for example, if the other stores are outselling them on one type of product. If so, they may need to initiate a sales promotion or provide more sales staff training.

Both groups need current and customized sales data to create self-service reports and perform analyses. It is your job to provide that data.

To accomplish these goals, you will create a flow that moves data out of an operational data store and that builds a denormalized table that can be used to run sales and analytic reports.

Note: Refer to the dmdemo sample data flow in ibisamp for the complete example. However, note that dmdemo has only one data target, while the flow you build will contain two.