DSXchange

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...

Ray, Thank you for the help! I won't try to update those files. I am noticing a limitation on the amount of data i can put into a reference file. At one point, i can't Provision the rule set. When i try to open the rule set from Designer, i get a "Could not load Rule Set ... [No message from re...

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...

Thank you JRodriguez. The challenge here is there are over 500 distributors sending product descriptions from thousands of suppliers who constantly change the unit names and amounts. One might send "12 pk" which the SME will know as 12 pack of bottles. Another distributor can send "12...

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...

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?

I found a way to perform this function. By taking the space out of STRIPLIST, it doesn't break the string into separate tokens. I am able to perform a lookup and return data using threshold settings. BEFORE \PRAGMA_START SEPLIST " ~`!@#$%^&*()_-+={}[]|\\:;\"<>,.?/'" STRIPLIST &quo...

Thanks Chulett! Here is some of the sample reference data: "SCHLAFLY OKTOBERFST 1/6","Schlafly Oktoberfest 1/6 barrel keg (5.16 gal)",800 "SCHLAFLY OKTOBERFEST 50","Schlafly Oktoberfest 50 liter keg (13.2 gal)",800 "SCHLAFLY OKTOBRFEST 4/6","Sch...

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 ...

Thanks Ray.

Yes, there is an entry in the .odbc.ini, see below.

[ODBC Data Sources]
MySQL_QM_Stage=MyODBC 3.51 Driver DSN
MySQL_QM_DataMart=MyODBC 3.51 Driver DSN

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...

I found a work around. Since the consuming party and software are demanding that the &lt's be removed, I recoded the job. Instead of using the XML Output Stage, I replaced it with a Transformer and added the XML definitions in the Description field. By so doing, I am getting the desired XML form...

I am now getting the needed rows outputted. My end user is now complaining that they can't parse the output from the Web Service because there are &lt instead of < symbols. They are using a product called Cast Iron. Is it possible to change the output in ISD to output <'s instead of &lt's? I...

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 ...

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...