Cross Join

Joins all possible first_name, middle_name combinations together.

You can also add a condition to constrain the resulting dataset.

2 new fields are added to the data stream:

• first_middle_name: concates the first_names and middle names.

• initials: returns the 2 character initials.

This method has two variants and returns a new string that is a substring of this string. The substring begins with the character at the specified index and extends to the end of this string or up to endIndex – 1, if the second argument is given.

Returns the value associated with the ${surname}. This is set in the Parameters tab in Transformation properties.

Joins all possible first_middle_name, surname combinations together. The output for initials is also excludes in the list various initials combinations.

Determine the order and selection of the data stream fields.

2 new fields are added to the data stream:

• boys_initials: returns the babys’ 3 character initials.

• boys_name: concates first_name + middle_name + surname

• Returns 5 sampled records.

• Returns Random seed ${seed}

• Reservoir Sampling allows you to select a set number of random records, from an unknown number ‘reservoir’ of records, i.e. not known beforehand.

• Use a different seed value to ensure no two ‘sets’ are the same.