...

In this exercise you will load reference data into your model which lists all the TV channels offered in each package. You will use this to break out each customer record, in Latest Package Update, into a set of records for each channel that the customer has ordered.

Load reference data

The database table SOURCE_PACKAGE_CHANNELS gives the list of channels available in each package.

• Create a database collector, using the datasource Rating and Billing, to read all the records from this table
• Create a stream from this database collector
• Run analysis on the stream

Create Stream for full channel list

Add a new stream to your model to hold the full channel list:

...