Duplicate Check Assembly


Number of input and output link

Number of input link : One
Number of output link : One

Duplicate Check Assembly () is used to detect duplicate records within a partition and append a duplicate indicator flag to each record.

This assembly does not remove records. Instead, it marks whether a record is a duplicate or not, allowing downstream processes to decide how to handle duplicates.

Functionality

For each record in a partition: Duplicate detection is performed locally within each partition, based on the configured key fields.

How It Works

Input and Output Structure

Input Record
[field1, field2, field3, ...]
Output Record
[field1, field2, field3, ..., duplicate_flag]
Where:

Example

Input Records (within one partition)
ID	Name	Amount
1	John	100
2	Alice	200
1	John	100
3	Bob	150
2	Alice	200
Output Records
ID	Name	Amount	Duplicate Flag
1	John	100	0
2	Alice	200	0
1	John	100	1
3	Bob	150	0
2	Alice	200	1

Important Characteristics

Common Use Cases

Limitations

Summary

The Duplicate Check Assembly identifies duplicate records within each partition and appends a flag indicating duplication status. It is a lightweight and efficient way to mark duplicates without modifying or removing any records, enabling flexible downstream processing.

Supported Engines

Map
Reduce
Spark 1.x
RDD
Spark 2.x
RDD
Spark 2.x
Dataset
Apache Beam
2.29.0 Batch
Apache Beam
2.29.0 Streaming
Apache Flink
1.12.0 Batch
Apache Flink
1.12.0 Streaming
Apache Tez
0.9.1
PySpark