tDuplicateRow properties - 6.1

Talend Components Reference Guide

EnrichVersion
6.1
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Studio
task
Data Governance
Data Quality and Preparation
Design and Development

Component family

Data Quality

 

Function

tDuplicateRow generates duplicate data from an input flow. It groups similar duplicates together and identifies the original record of each group by true.

This component can be used in combination with the tRowGenerator component to generate duplicate data.

Purpose

tDuplicateRow can be used to create duplicates with meaningful data for data quality functional testing purposes.

Basic settings

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. The schema is either Built-In or stored remotely in the Repository.

Since version 5.6, both the Built-In mode and the Repository mode are available in any of the Talend solutions.

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. Related topic: see Talend Studio User Guide.

 

 

Repository: You have already created the schema and stored it in the Repository. You can reuse it in various projects and Job designs. Related topic: see Talend Studio User Guide.

 

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.

Advanced settings

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

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

tDuplicateRow can not be used in Map/Reduce Jobs for the time being.

Limitation/prerequisite

n/a