DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 44 matches
Author Message
Resolved
 Topic: Limit on organization comparison tokens
pk7

Replies: 2
Views: 10445

PostForum: Infosphere Master Data Management   Posted: Tue Dec 22, 2015 1:35 pm   Subject: Limit on organization comparison tokens
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 ...
Resolved
 Topic: Limit on organization comparison tokens
pk7

Replies: 2
Views: 10445

PostForum: Infosphere Master Data Management   Posted: Thu Dec 17, 2015 12:02 pm   Subject: 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 AIRCRAF ...
 Topic: Truncate a single entity type
pk7

Replies: 0
Views: 4671

PostForum: Infosphere Master Data Management   Posted: Thu Jul 30, 2015 2:39 pm   Subject: 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 ...
 Topic: MDM Delta load process
pk7

Replies: 1
Views: 4998

PostForum: Infosphere Master Data Management   Posted: Mon Jul 28, 2014 4:09 pm   Subject: 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 ...
 Topic: Project deployment - No servers are defined in the workspace
pk7

Replies: 0
Views: 4321

PostForum: Infosphere Master Data Management   Posted: Fri May 16, 2014 10:49 am   Subject: 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 a ...
 Topic: Removal of hashed files
pk7

Replies: 3
Views: 2240

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Apr 15, 2014 3:00 pm   Subject: Removal of hashed files
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, es ...
 Topic: Removal of hashed files
pk7

Replies: 3
Views: 2240

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Apr 15, 2014 1:52 pm   Subject: Removal of hashed files
DataStage® Release: 8x
Job Type: Server
OS: Unix
I have reviewed several posts regarding removal of hashed files but still need some help. We are wanting to remove old hashed files from a DEVELOPMENT environment. It appears that all of the hashed ...
 Topic: Key Analysis on GUIDs
pk7

Replies: 1
Views: 2451

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Tue Mar 18, 2014 3:55 pm   Subject: Key Analysis on GUIDs
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 t ...
 Topic: Missing dataset file
pk7

Replies: 5
Views: 2480

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jan 22, 2014 5:29 pm   Subject: Missing dataset file
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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- ...
 Topic: "OVERRIDE token values not validated" error
pk7

Replies: 11
Views: 6611

PostForum: IBM QualityStage   Posted: Mon Dec 02, 2013 11:37 am   Subject: "OVERRIDE token values not validated" error
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 ...
 Topic: "OVERRIDE token values not validated" error
pk7

Replies: 11
Views: 6611

PostForum: IBM QualityStage   Posted: Mon Dec 02, 2013 10:47 am   Subject: "OVERRIDE token values not validated" error
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= ...
 Topic: "OVERRIDE token values not validated" error
pk7

Replies: 11
Views: 6611

PostForum: IBM QualityStage   Posted: Tue Nov 26, 2013 10:50 am   Subject: "OVERRIDE token values not validated" error
Hi Ray. I have absolutely no overrides at all in the rule set. I even attempted to put in an override to see if that helped but to no avail so I removed that one.
 Topic: "OVERRIDE token values not validated" error
pk7

Replies: 11
Views: 6611

PostForum: IBM QualityStage   Posted: Mon Nov 25, 2013 1:37 pm   Subject: "OVERRIDE token values not validated" error
Yes, my apologies.

This error is occurring in a standardization stage that has USPREP as the Rule and "ZQMIXNZQ" ADDRESS as the Column . Examples of the input data producing the warnings are:
...
 Topic: "OVERRIDE token values not validated" error
pk7

Replies: 11
Views: 6611

PostForum: IBM QualityStage   Posted: Mon Nov 25, 2013 11:49 am   Subject: "OVERRIDE token values not validated" error
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 an ...
 Topic: Matching on appended married names
pk7

Replies: 5
Views: 4251

PostForum: IBM QualityStage   Posted: Mon Sep 16, 2013 3:24 pm   Subject: Matching on appended married names
Thanks Ray but...

- what is REVERSE string? Is that a DS function? I can't find that one.
- how do I match rightmost characters with QS? That's exactly what I want to do but don't see a way to ...
 

 Jump to:   



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