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.
Search found 42 matches
- Tue Dec 22, 2015 1:35 pm
- Forum: Infosphere Master Data Management
- Topic: Limit on organization comparison tokens
- Replies: 2
- Views: 21277
- Thu Dec 17, 2015 12:02 pm
- Forum: Infosphere Master Data Management
- Topic: Limit on organization comparison tokens
- Replies: 2
- Views: 21277
Limit on organization comparison tokens
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 ...
- Thu Jul 30, 2015 2:39 pm
- Forum: Infosphere Master Data Management
- Topic: Truncate a single entity type
- Replies: 0
- Views: 14213
Truncate a single entity type
Is there a way to remove all data from the MDM DB for a single Entity type? We have multiple Entity types loaded (e.g. Person and Employer) and one of them (e.g. Person) was loaded incorrectly and we want to remove it without having to truncate ALL data for ALL Entity types and then realoading every...
- Mon Jul 28, 2014 4:09 pm
- Forum: Infosphere Master Data Management
- Topic: MDM Delta load process
- Replies: 1
- Views: 14996
MDM Delta load process
Can someone explain to me or suggest a tutorial that explains how to do a delta load with MDM ver 11? I have gone through the IBM bootcamp course but that topic was not covered. I have the bulk load process down pretty well but need to know how a delta load differs. Thanks!
- Fri May 16, 2014 10:49 am
- Forum: Infosphere Master Data Management
- Topic: Project deployment - No servers are defined in the workspace
- Replies: 0
- Views: 12975
Project deployment - No servers are defined in the workspace
I am a newbie to MDM. It appears that we may not have our configuration set up properly. When attempting to deploy a configuration project the deploy dialog shows no servers in the Server dropdown and the message "No servers are defined in the workspace" appears. Can someone help a newbie ...
- Tue Apr 15, 2014 3:00 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Removal of hashed files
- Replies: 2
- Views: 4263
Thanks Andy But even so, ALL the DATA.30 files (dozens of them in different directories) have exactly the same recent date and time. There is no way that they were all updated at the same time, especially in a Development environment where I know for certain that some of these hashed files have not ...
- Tue Mar 18, 2014 3:55 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Key Analysis on GUIDs
- Replies: 1
- Views: 4177
Key Analysis on GUIDs
We are profiling some tables that are joined together with GUIDs. When we get to Key and Cross Domain Analysis IA correctly identifies the PKs but does not identify FK candidates. I must admit that we have never gone this far into profiling so we may be doing something wrong here in order to identif...
- Wed Jan 22, 2014 5:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Missing dataset file
- Replies: 5
- Views: 4603
Missing dataset file
I have a DS job which has 4 different dataset files as inputs. If one of those files happens to be missing one day (it could happen) then the job blows up. Is there any way to simply ignore the non-existence of the file and continue processing with the others? I know that with Sequential files there...
- Mon Dec 02, 2013 11:37 am
- Forum: IBM QualityStage
- Topic: "OVERRIDE token values not validated" error
- Replies: 11
- Views: 10756
As mentioned in an earlier post there are currently no overrides. However, here are the contents: .FPO file: ;;QualityStage v8.0 \FORMAT\ SORT=Y ENPREPFP TBL .FTO file: ;;QualityStage v8.0 \FORMAT\ SORT=Y ENPREPFT TBL .IPO file: ;;QualityStage v8.0 \FORMAT\ SORT=Y ENPREPIP TBL .ITO file: ;;QualitySt...
- Mon Dec 02, 2013 10:47 am
- Forum: IBM QualityStage
- Topic: "OVERRIDE token values not validated" error
- Replies: 11
- Views: 10756
The structure is: Transformer----->USPREP Std stage------->Dataset file Columns coming into the Standardization stage are: CENSUS_GRP_ID:decimal[38,0] {delim=',', precision=38, scale=0}; SRC_TYP_CD:nullable string[max=5]; SRC_TYP_DESCR:nullable string[max=60]; CASE_ID:nullable decimal[38,0]; SHIPPIN...
- Tue Nov 26, 2013 10:50 am
- Forum: IBM QualityStage
- Topic: "OVERRIDE token values not validated" error
- Replies: 11
- Views: 10756
- Mon Nov 25, 2013 1:37 pm
- Forum: IBM QualityStage
- Topic: "OVERRIDE token values not validated" error
- Replies: 11
- Views: 10756
- Mon Nov 25, 2013 11:49 am
- Forum: IBM QualityStage
- Topic: "OVERRIDE token values not validated" error
- Replies: 11
- Views: 10756
"OVERRIDE token values not validated" error
Getting this warning which is ultimately causing an abort since our company policy only allows a max of 50 warnings before an abort is issued. Would like to eliminate the root cause of the problem and not just remove the limit of 50 warnings. Can't find any reference to a solution in the posts or on...
- Mon Sep 16, 2013 3:24 pm
- Forum: IBM QualityStage
- Topic: Matching on appended married names
- Replies: 5
- Views: 6937
- Wed Jul 17, 2013 10:10 am
- Forum: IBM QualityStage
- Topic: Copying USPREP rule set
- Replies: 11
- Views: 7871