DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
srds2



Group memberships:
Premium Members

Joined: 29 Nov 2011
Posts: 66

Points: 821

Post Posted: Mon Jul 15, 2013 8:59 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi, I am trying to understand the different types of Reference Match grouping. I have read the documentation but couldn't understand the difference between below types of matching and also if we are trying to get One input record matched with multiple Reference Records then what kind of Reference match type we should go for and Viceversa.

Many-to-one
Many-to-one Multiple
Many-to-one Duplicate

Can anyone help me to better understand these reference match types.

Thanks a lot in advance!
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54546
Location: Sydney, Australia
Points: 295766

Post Posted: Mon Jul 15, 2013 9:44 pm Reply with quote    Back to top    

A two-source match identifies records in one source that have similar attributes to records in a second source (for example when enriching a data source from a reference source). In one-to-one match ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
srds2



Group memberships:
Premium Members

Joined: 29 Nov 2011
Posts: 66

Points: 821

Post Posted: Wed Jul 17, 2013 8:13 am Reply with quote    Back to top    

Thanks Ray for the information.

for one to one matching : Lets say we have 1 source record similar to two reference records then the second reference record will fall under which of the output category (Match, Clerical, Reference Duplicates, Reference Residual?) Because in one to one mathing one source record should be matched to only one reference record. I coldnt get this infornation in the documentation.

I read the scenarios given in the documentation but still couldnt understand the exact difference or when should we use Many to one Vs Many to one Multiple Vs Many to One Duplicate. Can you please provide me some more information on these two types?

Thanks a lot in advance.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54546
Location: Sydney, Australia
Points: 295766

Post Posted: Wed Jul 17, 2013 4:32 pm Reply with quote    Back to top    

The only possible answers are (a) "it depends" on the characteristics of the data and (b) if you have this knowledge a priori then you probably should be using a many-to-one match rather than one-to-o ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours