Multiplying out using Cartesian product merge, user source, and derive dummy

To produce every combination from two or more sets of records requires a Cartesian product operation. The recipe Cartesian product merge using key-less merge by key shows the simplest way of doing this in Modeler, by using a key-less merge. The current recipe shows a different method of generating a Cartesian product that uses dummy keys; this method dates from before the key-less merge operation was included in the software. This recipe also illustrates a slightly different data preparation situation; that is, in this case a set of 1000 customer records is multiplied out with a set of codes, the result being each customer record is duplicated and appended to each available code.

Getting ready

This recipe uses the datafile, cup98LRN.txt and the stream file, Multiply_Out.str

How to do it...

To perform a Cartesian product merge by using dummy keys:

1. Open the stream Multiply_Out.str by navigating to File | Open Stream.

2. Run...