DSXchange

hi, yeah normally your qualitystage will pick the DSN from your windows workstation. you have to create a local dsn which refer to your AIX box database and use that dsn in matching. better dont run matching job. after you update the matching , run the undup job . undup will fetch match spec info an...

hi, yeah normally your qualitystage will pick the DSN from your windows workstation. you have to create a local dsn which refer to your AIX box database and use that dsn in matching. better dont run matching job. after you update the matching , run the undup job . undup will fetch match spec info an...

Hi all, am matching on name and registration number. if registration number is missing in one of the record then still i want that records to be included in matchset example: name reg abc ltd 1234 abc ltd i tried with [critical missing ok] on registration field , but i din't get the expected result....

could you send me the data which doesnot get converted or its general pattern.

send me the output field name in dictionary too

hi ray, i can't include the match specification in the sequence job. i can't drag and drop the match specification when i open the sequence job . i had doubt that "if we include the match specification is it necessary to update the test environment every time ? " did you created the sequen...

HI GURUS , i want to schedule the sequence job "Standardization->frequency->matching->unduplication" But, in the sequence job i can't include the match specification ! How could i create a sequence job from stan - undup Many thanks in Advance Vairam[/i]

Install the fixpack then you will get the data in osherrorlog.txt and osherror.txt .

Hi , thanks for your reply RAY . In Earlier version 7.5 , the maximum number of pass is 7. i hope it should be more than 7 or atleast 7 in version8 . I tested the same 7 passes with 20,000 records and i got the result. Am running now with 4million records ,12GB Ram,500GB disk space. it create datase...

hi all, I had 7 passes in matching. i got error while its processing 6th pass. i got this error in OSHERRORLOG.txt. Could anybody help me to figure out what is this error exactly? ##I IIS-DSEE-TFCN-00001 13:07:47(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.0.1.4665 Copyright (c)...

Hi guys, Our server reside in AIX and we accesing client in windows. in match specification while testing ODBC connectivity, i could only see the DSN created in my local machine . i couln't see the DSN created for db2 database in AIX machine . How to get that DSN? thanks in Advance guys

hi neena, If you installed NLS in your product you may have this problem. Due to incompatible codeset you may have this error. visit this url .this might help you http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r0/index.jsp?topic=/com.ibm.swg.im.iis.productization.iisinfsv.rnotes.kpw.doc/topics/...

Hi guys, How you all doing? AM doing matching on first three company words. if any 2 company name had first two similar words and dint have the 3rd word.i want that name also in that match. if company name comes with 3 word like below it is matched. abc pvt ltd abc pvt ltd if company name comes with...

Hi all, I am currently facing a problem in my matching consecutive runs. After my first run i got result with some multiple matchset with identical matchsetid. In the second run if the same company record comes in .it should go in same matchset of the first run. See the below example and help me wit...

Hi Bob, Thanks for the response. 3 pass match specification runs if confidence level is lower in 3rd pass. In 3rd pass i had 3 columns with CHAR algorithm and i want exact word match.So i increase the confidence to .999 M and .998 u probability in 3rd pass . i monitor the job. it create dataset and ...

Hi QS Folks, Greetings. I ams struggling in my matching process while running 4 parse match with 4 million records. The process stops after creating 3rd dataset, it has to create 5 dataset for 4 parse. I really don't know what is the problem is. But I could run very successfully when I run 3 parse m...