Quality Stage Reference match
Posted: Thu Oct 13, 2011 2:50 pm
We have customer information in two databases , now I am doing standardization and un duplication using Quality stage
And loading into customer master table (this table holds information of customer key , first name , last name etc..
address details we are maintaining in a separate table)
During initial load process I am going to process all records and make them master , dups and residual data.
But for the incremental load I am going to apply CDC logic and process only new/ changed rows .
as per our business process for changed rows should use the existing customer key.
In this case do I need to use reference match stage for matching purpose ?
Please let me know if you have any additional questions.
And loading into customer master table (this table holds information of customer key , first name , last name etc..
address details we are maintaining in a separate table)
During initial load process I am going to process all records and make them master , dups and residual data.
But for the incremental load I am going to apply CDC logic and process only new/ changed rows .
as per our business process for changed rows should use the existing customer key.
In this case do I need to use reference match stage for matching purpose ?
Please let me know if you have any additional questions.