DSXchange

I included customer ID in match commands and gave agreement & disagreement weight as 10 and -15 respectively.

Also cutoff values section match and clerical fields accept values from 0 to 999999.99.

I tried with different values for match and clerical field , but still facing same issue.

I included customer ID in match commands and gave agreement & disagreement weight as 10 and -15 respectively.

Also cutoff values section match and clerical fields accept values from 0 to 999999.99.

I tried with different values for match and clerical field , but still facing same issue.

Thanks you very much for your suggestion . I tried to have match command as customer id , but still same issue.

I will try the option cutoffs below zero.

pass1

block commadsprimaryname_USNAME
matchfirstname_USNAME
zipcode_USAREA
housenumber_usaddr
streetname_usaddr

match commands

address1
state code
postal code

pass2

block commands

Customer id

no match commands

I have a match specification with two passes , match type I am using is Unduplicate Dependent . In first pass I am doing address details match , based on address match I am seeing master and duplicates records. second pass is customer id match , if there are different address with same customer id ,...

Hi Ray, here are my findings . please let me know if i am wrong. match cutoff is used identify match records . record pairs with compositer weight more than cutoff are reliable match. clerical cutoff is used identify posible match records . record pairs with compositer weight more than clerical cuto...

In match designer window thre is cut off values section , do I need to set Match and Clerical section to 23.68?

is it advisable to add address1 column also into block section?

Please let me know

I am working on consolidating customer data exist in two different databases. I setup match specification in below way. block commnds are MatchfirstnameNYSIIS_USNAME MatchPrimaryname_USNAME STATE_CD ZIP CODE match command Matchfirstname_USNAME (Mprob 0.9 , Uprob 0.1 , Param1 850) MatchPrimaryname_US...

Thanks for the replies . I am able solve this issue by moving the date of birth column to Match command section. now my block commands are MatchFirstNameNYSIIS_USNAME, PrimaryName_USNAME, CityName_USAREA, StateAbbreviation_USAREA & ZipCode_USAREA. Match commands colmuns are MatchFirstName_USNAME...

Hi , I created and Match specification and trying to run using Test All Passes option , getting below error message ... Please help me , how to resolve this issues i have blocking columsn mentioned first name , last name , city , state , zip and country . i didn't specify any match commands / cut o...

Hi , I created and Match specification and trying to run using Test All Passes option , getting below error message ... Please help me , how to resolve this issues ##I IIS-DSEE-TFCN-00001 11:01:08(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.5.0.5946 Copyright (c) 2001, 2005-2008...