DSXchange

Thanks Scott -----Original Message----- From: Scott Brooks [mailto:sbrooks@psu.edu] Sent: Friday, May 23, 2003 8:15 PM To: datastage-users@oliver.com Subject: Re: Doubt Hi Senthil, If the files arent too large, you could use a custom routine (DataStage Basic) to read the one file into an array. Then...

Name and address cleansing is always extremely tricky (complex); there are so many business rules that might apply, particularly if you have to handle names and addresses in multiple countries. It is better to use a product that is specifically for this kind of task, such as INTEGRITY (which is part...

Have you contemplated using a Merge stage doing a "Complete Set" join between the two sequential files, then performing your comparisons in a following Transformer stage? ----- Original Message ----- From: "Senthil Kumar B" Date: Fri, 23 May 2003 11:58:09 +0530 To: Subject: Doubt > Hi: > > I have a ...

LOCATE and FIND statements in DataStage BASIC search for an exact match. FINDSTR can be used to search for a partial match. The MATCHES operator can be used to match a pattern, by which means a "one string contains the other" comparison can be achieved. ----- Original Message ----- From: Date: Fri, ...

The Integrity module of the Ascential Suite is a fully integrated Data Cleansing tool - I would suggest you take a look at www.ascential.com for further details or contact your local team Regards Howard -----Original Message----- From: Senthil Kumar B [mailto:Senthil_KumarB@mindtree.com] Sent: 23 Ma...

Senthil, You could start your job with Job Control code to build a dynamic array of the second sequential file, as Scott suggests, and load it into named common. Then, for each row in the first sequential file, call a routine on the transform derivation line that locates the text (using the LOCATE s...

This is a topic for an orphaned message.

Depending on the degree of need(budget), you may want to investigate the INTEGRITY option/add-on for DataStage XE. This offers virtually unlimited matching capabilities. It has historically been used for matching names and addresses, part descriptions from multiple vendors, and for extracting specif...

Senthil Soundex is not meant to be an exact match. Most soundex routines return a point value like 600 for Smith. If you use plus or minus 50 or 100 points then you will return Smythe or Smiht as well as Smith. Soundex will do what you want if used properly. Thanks Kim. Kim Duke DsWebMon - Safely Co...

Hi, Im trying to help out someone here - does anyone know how to connect a DB2 server to the AIX ? db2 => CATALOG TCPIP NODE REMOTE SERVER 4325 DB20000I The CATALOG TCPIP NODE command completed successfully. DB21056W Directory changes may not be effective until the directory cache is refreshed. db2 ...

Hi Senthil, If the files arent too large, you could use a custom routine (DataStage Basic) to read the one file into an array. Then you can read through the input file and for each record do a For - Next loop through the array (i.e. nested loops). You can then write out what you need. I hope this he...

I used soundex but it doesnt give desirable output. DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any virus...

Senthil You could do a soundex lookup. In the old Universe manuals it outlined a soundex routine. You can download those manuals from IBM. If you cannot find it then let me know. Thanks Kim. Kim Duke DsWebMon - Safely Control DataStage from the Web www.Duke-Consulting.com -----Original Message----- ...

**************************Disclaimer************************************ Information contained in this E-MAIL being proprietary to Wipro Limited is privileged and confidential and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or di...

Hi: Please provide me ideas to do data cleansing in datastage. For example... Name: Bob William (Standard Name) Input : Bob Wilam The input should be cleansed to the standard format. Please suggest some ideas how this can be done in datastage. Senthil DISCLAIMER: This message (including attachment i...