tDuplicateRow Standard properties

Schema and Edit schema

A schema is a row description. It defines the number of fields (columns) to be processed and passed on to the next component. When you create a Spark Job, avoid the reserved word line when naming the fields.

Click Sync columns to retrieve the schema from the previous component in the Job.

The output schema of this component contains one read-only column, ORIGINAL_MARK. This column identifies by true or false if the record is an original record or a duplicate record respectively. There is only one original record per group.

Built-In: You create and store the schema locally for this component only.

Repository: You have already created the schema and stored it in the Repository. You can reuse it in various projects and Job designs.

Percentage of duplicated records

Enter the percentage of the duplicate rows you want to have in the output flow.

Distribution of duplicates

Name: Select the probability distribution you want to use to generate duplicates: Bernoulli distribution or Poisson distribution or Geometric distribution.

Average group size: Set the average number of duplicate records you want to generate in the groups of duplicates.

Modifications

Define in the table what fields to change in a row and how to change them:

-Input Column: Select the column from the input flow from which you want to generate duplicates through modifying its values.

-Modification Rate: Enter a rate of the modifications you want to have in the duplicate record generated from an input column. The rate is a value between 0 and 1. If you set the rate to 0, no modification will be done. If you set the rate to 0.5, modification will be done in average every two rows. But if you set the rate to 1, modification is done at each row.

These modifications are based on the function you select in the Function column and the number of modifications you set in the Max Modification Count column.

-Function: Select the function that will decide what modification to do on a value to duplicate it. For example, you can decide to have exact or approximate duplicate values through replacing or adding letters or numbers, replacing values with synonyms from an index file or deleting values by setting the function to null or blank.

The Function list will vary according to the column type. For example, a column of a String type will have an Add letters option in the list while a column of an Integer type will have an Add digits option in the list. Also, the Function list for a Date column is date-specific. For further information about the functions used on Date columns, see Date functions in tDuplicateRow.

-Max Modification Count: Enter a maximum number of the values to be modified.

-Synonym Index Path: Set the path to the index file from which you use the synonym.

This field is available if you select the Synonym replace function which means that the value in the duplicate record is replaced by one of its synonym, according to the given the rate.

You must use the tSynonymOutput component to create a Lucene index and feed it with synonyms. For further information about how to create a synonym index and define the reference entries, see tSynonymOutput.

Seed for random generator

Set a random number if you want to generate the same sample of duplicates in each execution of the Job.

Repeating the execution with a different value for the seed will result in a different duplicate sample being generated.

Keep this field empty if you want to generate a different duplicate sample each time you execute the Job.

tStat Catcher Statistics

Select this check box to collect log data at the component level.

Usage rule

This component helps you to generate duplicate data of an input flow according to certain criteria and use it for testing purposes.