Search found 6 matches

by tcat2000
Sun Jul 31, 2005 10:22 am
Forum: IBM QualityStage
Topic: records that should match but don't
Replies: 4
Views: 3210

i just discovered something wierd... my test file has 5326 records. i am blocking on customer id and matching on the same column. the file does not have name and address info .... just account numbers, ssn & customer id. this is a test file. this file should have only 1 grouping... customer id a...
by tcat2000
Sat Jul 30, 2005 8:57 pm
Forum: IBM QualityStage
Topic: records that should match but don't
Replies: 4
Views: 3210

i'm sorry to say that i haven't gotten to the aggregate weights for XA and DA entries yet... i couldn't find anything in the manual relating to it. On my extract file, i constructed a column with the following command: MOVE @SET8 It created a column called DF and i believed that is the group identif...
by tcat2000
Sat Jul 30, 2005 3:33 pm
Forum: IBM QualityStage
Topic: records that should match but don't
Replies: 4
Views: 3210

records that should match but don't

hi, i ran my customer file thru qualitystage and undup on customer id. the output is perfect with the exception of 1 group of customer ids. It turned out that this group contain 5000 records and is the largest group in my file. The second largest group contains 1200 records and it was grouped okay. ...
by tcat2000
Fri Jul 22, 2005 4:26 pm
Forum: IBM QualityStage
Topic: INVp.FRQ Report Not Accurate
Replies: 1
Views: 2431

INVp.FRQ Report Not Accurate

Hi, I'm going thru the getting started tutorial with my own data file and in the INVp.FRQ report, the frequency column is sometimes off by a few records. Is this normal?? Is close enough for decision making purposes by it's not exact. Any insights on this issue?? I'm on QualityStage 7.5 on Windows P...
by tcat2000
Tue Jun 07, 2005 12:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Seems Corrupted
Replies: 5
Views: 2442

Hash File Seems Corrupted

I have a job that works correctly with a hash file. When I view data in the input tab... all data seems ok... all data seems ok in the output tab too. I have another job that's not working with a hash file. All data seems ok in the input tab... but when I look into the output tab... column definitio...
by tcat2000
Thu Jun 02, 2005 11:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to strip leading 0's from numeric data
Replies: 2
Views: 1682

how to strip leading 0's from numeric data

Hi,

does anyone know how to strip leading zeros from numeric fields.

ie. 021121234 - > 21121234

thanks