DSXchange

Well I made copy of the rule set in question and copy works ok.
So delete/rename and it is ok now.

Hi all, I have created custom rule set by copying existing CANAME set. I have changed length of come columns in dictionary file and added couple names in classifications, Everything was working fine for about 2 months, Today I was creating new job with standardization stage that uses this rule set b...

I have created multiple passes one for each address type as suggested by Robert. Blocking columns are first pass streetname NYSIIS and FSA second pass FSA, RR Type and RR value third pass FSA, Box Type and Box Value This made thinks much better. Still there are some issues to deal with meaning I nee...

Thank you guys, I am leaning towards that solution myself. Robert I was blocking on FSA - first 3 characters of postal code and custom built address key, This address key was build using phonetic streeet name appended with RR type RR value, BOX Type BOX value. There are 4 type of addresses Street , ...

Thanks Stuart, I have looked at defalut agreement and disagreement values and they are as bellow. I guess StreetSuffixQualifier can be removed as there is no values at all in the data. I would appreciate if you coud reccomend some overrides. Also would it help if I change uprob for fields that have ...

Just found this:

http://www-01.ibm.com/support/docview.w ... wg21573053

Since I am using MULT_UNCERT overides will not work.

Thank Ray, Can not see your post yet (just paid my membership few minutes ago). Here are some other considerations I have. I did separate testing on name matching and name alone is getting weights between 5 and 20. Around 10 I am getting dependable match. In my match I am comparing all elements of s...

Hi all, I am in need of a little help. I appologize if this topic was alredy disussed I did search but could not find my answer. We are trying to match incomming data to our master record set in database. Database contains bussiness names along with address and phone information. We have designed ma...

Just found this
viewtopic.php?t=140368&highlight=null

Did not know that records are dropped if they hove null values.

Thanks DSXCHANGE

Hi all, I am new to QS and trying out this for the first time. I did lot of search and reading but can't figure this one. I have 100 records in the input which I run to the standardize stage. My output does contain only records that pass standardization. Records in the output are dependent (it looks...

[quote="ray.wurlod"]The limit is the largest integer that DataStage BASIC can handle. If you regard this as 2147483647 you won't be far wrong. Actually the largest number that can be handled without error has 14 digi ...[/quote] Thanks Ray, Unfortunately I am not premium member (yet) but y...

Hi Chulett, it does not print any details about error in the log. Just generic encounred error in transformer type of message. Server:LXDSPRD1.TRANSUNION.CA Project:warehouse_load Job No:266 Job name:jb_AF_DW_ACCT_LOAD_LOAD Invocation: Event Number:130 Event type:Warning User:dsadm Timestamp:4/27/20...

Hi there, I have simple job that reads from flat file adds surrogate key using KeyMgtGetNextValue function and loads data to the db2 database. It worked great until recent and now fails in the transformer where it assignes surrogate key. Is there limit (max int value) in the KeyMgtGetNextValue funct...

Was not datastage issue after all, Human error.
Last job that was run in the whole process was the first job again which would overwrite my hash file.

Hi all, I am running into following issue. I have one job (subject) that loads one table from source to destination. In the process it creates hash file that would be used in any sub-sequential job for look ups . Has file has 2 columns file_id, subject_id where file_id is a key. There is about 6 oth...