DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
pk7
Participant



Joined: 03 Aug 2007
Posts: 44
Location: Kansas CIty
Points: 581

Post Posted: Thu Dec 17, 2015 12:02 pm Reply with quote    Back to top    

It seems that when organization names are derived they produce a compare string that contains a maximum of four non-anonymous tokens. For example, let's say we have these two records:

ACME AIRCRAFT PARTS CO DBA BIG DOG MECHANICS
and
BIG DOG MECHANICS

then, after elimination of anonymous values like CO and DBA, the two comparison strings are:

ACME:AIRCRAFT:PARTS:BIG
and
BIG:DOG:MECHANICS

Notice that the first comparison string only contains the first four non-anonymous values. Hence the matching is less than desirable.

How can we overcome this limit of four tokens? The Max Bucket Tokens limit is obviously not the problem as we have that set at 6.
pk7
Participant



Joined: 03 Aug 2007
Posts: 44
Location: Kansas CIty
Points: 581

Post Posted: Tue Dec 22, 2015 1:35 pm Reply with quote    Back to top    

Just discovered the solution:

In the CXNM Name standardization, set Derivation Arguments to the number of tokens desired to be included in the comparison string. IBM indicates that the max for the CXNM standardization is 8.
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: 53844
Location: Sydney, Australia
Points: 292224

Post Posted: Tue Dec 22, 2015 3:36 pm Reply with quote    Back to top    

Thank you for posting the solution.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
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