Creating complex test data using tRowGenerator, tFlowToIterate, tMap, and sequences

This recipe shows how a more complex set of test data can be created. In this example, we will build a set of CSV data ready to be loaded into a database which has the following structure:

• Customer has 1 or more orders
• Order has 1 or more order items

Getting ready

1. Open the jo_cook_ch10_0110_complexTestData job.
2. You will see a section of code that has been deactivated. Do not activate this code until later in the exercise.
3. Run the job, and you will see that the customer file is created.

How to do it...

The steps for creating complex test data using tRowGenerator, tFlowTolterate, tMap, and sequences are as follows:

1. Activate components tFixedFlowInput_2, tMap_2, and tFileOutputDelimited_2. These are exact copies of the customer create components.
2. Change these newly activated components detailed as follows:
   1. Open tFixedFlowInput_2 and change Number of rows to Numeric.random(1,5).
   2. Open tMap_2. Change the name of the variable...