Search found 84 matches

by pattemk
Mon Nov 29, 2010 12:07 pm
Forum: IBM QualityStage
Topic: cass changing names
Replies: 7
Views: 4440

thanks..!
by pattemk
Wed Nov 24, 2010 7:05 pm
Forum: IBM QualityStage
Topic: cass changing names
Replies: 7
Views: 4440

thanks for replying..i know if cass can not validate any address, the CASS_Zip4, CASS_CarrierRoute and CASS_DeliveryPoint will be null, do we have something similar like this for identifying the records that cass changed ?
by pattemk
Wed Nov 24, 2010 4:54 pm
Forum: IBM QualityStage
Topic: cass changing names
Replies: 7
Views: 4440

thanks for prompt reply..do you know why cass behave like this?
by pattemk
Wed Nov 24, 2010 3:33 pm
Forum: IBM QualityStage
Topic: cass changing names
Replies: 7
Views: 4440

cass changing names

Hi, I am using cass stage to validate and then compare the addresses of my two input sequential files. for this address 1701K STATE ROAD 96,GREAT BEND,ks cass stage changed this to 1701 K 96 HWY,GREAT BEND,ks both are valid address, but it makes it hard while doing the comparision moreover if the in...
by pattemk
Tue Nov 23, 2010 11:45 am
Forum: IBM QualityStage
Topic: Soundex function in transformer stage Vs NYSIIS field
Replies: 2
Views: 3153

Soundex function in transformer stage Vs NYSIIS field

Hi, I am trying to compare two sequential file on their names and filter out the one that does not match. the data in these files can be in many different ways which is hard to standardize each and every name. I am using standardize stage to get the NYSIIS name for every name and then do the compare...
by pattemk
Fri Nov 12, 2010 12:53 pm
Forum: IBM QualityStage
Topic: Quality stage error
Replies: 3
Views: 2920

[quote="rjdickson"]I suggest you open a support ticket. You may need a patch.[/quote]


Just an FYI,
If i just use only one cass stage in the job, the finishes sucessfully.
by pattemk
Fri Nov 12, 2010 12:19 pm
Forum: IBM QualityStage
Topic: Quality stage error
Replies: 3
Views: 2920

Quality stage error

Hi, Below is my job , my input is an seq file --> copy stage and below remove duplicates --> dataset | copy -->cass --> dataset | cass --> dataset my input is pipe delimited, arounf 29,000 records. i am getting the following error APT_CombinedOperatorController,0: ???(1949870):Fri Nov 12 09:50:26 PS...
by pattemk
Fri Nov 12, 2010 11:34 am
Forum: IBM QualityStage
Topic: cass stage issue
Replies: 2
Views: 2957

Hi staurt, thanks for the prompt reply, 123 is just to give an example. below is the exact address which changes changes it to the address which is 3 miles apart 9600 South IH-35 Svc Road SB Ste S 225 Austin, TX 78748 if you put the above address and process through cass, cass could able to validate...
by pattemk
Thu Nov 11, 2010 5:00 pm
Forum: IBM QualityStage
Topic: cass stage issue
Replies: 2
Views: 2957

cass stage issue

Hi, My input has data such as 123 ABC WAY, When passed through CASS , cass could able to validate this address it got changed to 123 ABC BND, i tried to search in google and both address point to same location. But there is an another record which cass could able to validate it but changed the addre...
by pattemk
Thu Nov 11, 2010 4:45 pm
Forum: IBM QualityStage
Topic: Custom rule sets
Replies: 31
Views: 15012

ISD Job? what is an ISD Job? and how do you specify the parameter to 10000? please advice [quote="JRodriguez"]Kennyapril, Reading through your post look like you just need a QS job with a CASS std stage exposed as a service using ISD CASS don't return all addresses from the USPS reference ...
by pattemk
Fri Nov 05, 2010 3:45 pm
Forum: IBM QualityStage
Topic: cass stage usage
Replies: 0
Views: 1230

cass stage usage

Hi,

I am using one cass stage in one job on around 5000 records, i was wondering if the performance will effect or is it a good practice to use more than one cass stage in one job? (irrespective of input volume)

kindly suggest the good practice while using cass stage.

thanks
by pattemk
Tue Nov 02, 2010 5:20 pm
Forum: IBM QualityStage
Topic: Cass stage performance
Replies: 5
Views: 3318

just an fyi, the project is using only one node. i know this might be reason. but wondering if processing 50,000 records for 45 minutes is really too long to finish on one node. and what are the thumb rules that we should do when using cass stage. please advice. [quote="lstsaur"]That's way...
by pattemk
Tue Nov 02, 2010 4:46 pm
Forum: IBM QualityStage
Topic: Cass stage performance
Replies: 5
Views: 3318

approx 50000(but can vary) seq file --> cass --> seq file currently it is taking me 45 minutes to process 50,000 records. i am wondering if there are any tuning tips while using a cass stage. thanks for helping [quote="stuartjvnorton"]Throw us a bone here: you've given us nothing to work w...
by pattemk
Tue Nov 02, 2010 3:17 pm
Forum: IBM QualityStage
Topic: Cass stage performance
Replies: 5
Views: 3318

Cass stage performance

Hi,

I did search but could not find much help.

I am trying to know the reasons why a job using cass stage takes too long to finish.

what can be done to improve the performance when using a cass stage in a job.

things that we should not be doing while using a cass stage.

Please advice
by pattemk
Mon Oct 25, 2010 3:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: need logic to filter
Replies: 6
Views: 2730

need logic to filter

Hi,

I am trying to get logic to filter out only those records from my input whose left most character starts with any alphabets or any number.

example

* xyz
abc
2 gt
@yt

i want to output only abc and 2 gt.

Please advice

thanks