view to specify how the transformation selects input data for analysis. Configure the property when you configure the Match transformation to read a persistent store of index data. The Match property refines the options that you set on the
Match Type
view.
You can configure the Match property to perform the following types of analysis:
Compare the data source records with the index data records
To look for duplicate records between the data source and the index data tables, select
Exclusive
.
When you select the Exclusive option, the Match transformation compares the data source records with the index data store. The transformation does not analyze the records within the data source or within the data store.
Select
Exclusive
when you know that the index data store does not contain duplicate records, and you know that the data source does not contain duplicate records.
Compare the data source records with the index data records, and compare the data source records with each other
To look for duplicates in the data source and to look for duplicates between the data source and the index tables, select
Partial
.
The transformation compares the data source records with the index data store. The transformation also compares the records within the data source with each other.
Select
Partial
when you know that the index data store does not contain duplicate records, but you have not performed any duplicate analysis on the data source.
Compare all records in the data source and the index tables as a single data set
To look for duplicates between the data source and the index tables, and to look for duplicates within the data source and within the index tables, select
Full
. The default option is Full.
The transformation analyzes the data source and the data store as a single data set and compares all record data within the data set.
Select
Full
when you cannot verify that either data set is free of duplicate records.
ASK INFAPreview
