Skip to Content
0
Sep 28, 2010 at 04:17 PM

Match Transform Help

174 Views

Folks,

Need some clarification on how to use the Match transform. I really can't figure this transform out. I have read the designer guide and reference guide constantly and I am at my wits end. I also am not really sure if it is something I should be using since what I feel is what I am really trying to do is a search.

I am trying to take data from one file and compare fields such as first name, last name, phone number email address etc and trying to find matches of this data in another file. My assumption was that this transform would take data from multiple sources such as 2 files in my example and allow me to perform some match. Out of the transform I would then get the records that match.

This does not seem to be the case. I have no clue what is coming out of this transform. Also I have no idea how to pass multiple sources in. If the transform only takes one source of data in which I believe is the case then I would have to use a merge transform.

How do I go about telling this transform that a certain set of records are just used for comparison and another set of records are to be used to look-up and find duplicates.