Search found 40 matches
- Mon Sep 18, 2017 7:46 am
- Forum: IBM QualityStage
- Topic: Updating reference lookups programmatically
- Replies: 5
- Views: 21324
Robert, That is what i originally thought, that there were duplicates. I searched for that one additional row that caused the issue and it wasn't a duplicate. I even tried to add a different row and got the same error. Keep in mind that i am not tokenizing, i am matching on the entire string. Thanks...
- Fri Sep 15, 2017 9:04 am
- Forum: IBM QualityStage
- Topic: Updating reference lookups programmatically
- Replies: 5
- Views: 21324
- Wed Sep 13, 2017 7:56 am
- Forum: IBM QualityStage
- Topic: QualityStage - How to match string with spaces
- Replies: 8
- Views: 23242
Thank you JRodriguez I agree with your approach and everything you mentioned. The company already has the cleansed target data that all customers need to match to. My first deliverable is to create a reference table that has all the raw data and its cleansed target equivalent. So this is a many to o...
- Sat Aug 26, 2017 8:53 am
- Forum: IBM QualityStage
- Topic: QualityStage - How to match string with spaces
- Replies: 8
- Views: 23242
- Sat Aug 26, 2017 8:37 am
- Forum: IBM QualityStage
- Topic: Updating reference lookups programmatically
- Replies: 5
- Views: 21324
Updating reference lookups programmatically
I am creating a user involved process where scrubbed data needs to be approved by a SME. For data that has a low threshold, the user needs to approve or change the output then have that change inserted into the reference lookup so the next run will scrub it, return a higher threshold, and pass it th...
- Sat Aug 26, 2017 8:13 am
- Forum: IBM QualityStage
- Topic: Creating new output columns
- Replies: 1
- Views: 15757
Creating new output columns
I need to add new custom output columns but I don't have the "manage out columns" link. How do I create new custom columns?
- Fri Aug 25, 2017 3:17 pm
- Forum: IBM QualityStage
- Topic: QualityStage - How to match string with spaces
- Replies: 8
- Views: 23242
- Fri Aug 25, 2017 12:22 pm
- Forum: IBM QualityStage
- Topic: QualityStage - How to match string with spaces
- Replies: 8
- Views: 23242
- Fri Aug 25, 2017 11:00 am
- Forum: IBM QualityStage
- Topic: QualityStage - How to match string with spaces
- Replies: 8
- Views: 23242
QualityStage - How to match string with spaces
I am trying to match product descriptions to a clean list of product descriptions. How can I do this? Since everything gets broken down into tokens, I can't do a long string match. I HAVE to match this way. I can't standardize using individual tokens due to multiple companies. Raw data: ABC company ...
- Fri Jul 13, 2012 9:10 pm
- Forum: General
- Topic: New MySQL ODBC Connection Not Working
- Replies: 4
- Views: 5494
- Fri Jul 13, 2012 2:39 pm
- Forum: General
- Topic: New MySQL ODBC Connection Not Working
- Replies: 4
- Views: 5494
New MySQL ODBC Connection Not Working
Hello All, Please help. I cannot get a new MySQL database to be usable with Datastage 8.7. I have tried using the 32 bit and 64 bit odbc driver that comes with MySQL. I can get past the first part of the import, the connection and table list get populated. The issue is when I try to import ODBC meta...
- Wed Feb 22, 2012 9:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Web Service (ISD Output Stage) Returning only one row
- Replies: 9
- Views: 9026
- Tue Feb 21, 2012 10:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Web Service (ISD Output Stage) Returning only one row
- Replies: 9
- Views: 9026
- Mon Feb 20, 2012 1:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Web Service (ISD Output Stage) Returning only one row
- Replies: 9
- Views: 9026
Erinie, Thanks for the reply. I was hoping to hear from you. Here is the job design in a nutshell: ISD Input >> XML Input >> Transformer >> Stored Proc >> XML Output >> ISD Output The consumer of the data is using Cast Iron, an IBM product to parse the SOAP Response. There skill level is not at the ...
- Mon Feb 20, 2012 11:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Web Service (ISD Output Stage) Returning only one row
- Replies: 9
- Views: 9026
Web Service (ISD Output Stage) Returning only one row
Problem: After receiving the SOAP Response, I am only getting one row of XML formated data out, I should have more. For some reason, ISD web services seems to give me two options. One, output all my XML data within one row, or Two, into an array. If I output all my XML columns out, I get one row pe...