We have source data coming in person table , as part of initial load process , I standardized and did unduplicate process to categorize master, duplicate and residual records and finally loaded into customer master table.
During incremental load process I am using reference match stage to compare customer master data (which is loaded during initial load) versus new/changed person data.
I am using match type Many-to-one Multiple to get master, duplicate and residual datasets records after unduplication using reference matchstage.
But I am getting master and residual datasets. When I load master data into some temporary table
I saw duplicate records. I expected one record should go to master data and rest should go to duplicate dataset.
I also tried with other options Many-to-one & Many-to-one Duplicate
Please advice me to correct this.
Quality Stage Reference match help
-
- Participant
- Posts: 29
- Joined: Sun Jul 22, 2007 3:25 pm
Quality Stage Reference match help
Vijaya K Dasari
Re: Quality Stage Reference match help
What columns are used for blocking and matching in reference match specification?
Re: Quality Stage Reference match help
What are your cut-off values? Change the cut-off values and see if that gives you the desired output.