Search found 406 matches

by JRodriguez
Tue Sep 15, 2009 7:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem in reading response from MQ
Replies: 11
Views: 5752

Well . .. There are two properties in MQ Connector stage that you would like to set to read the entire content of the queue and purge messages already processed Message quantity = -1 ( read all messages in the queue) Message read mode = delete ( After reading the message MQ connector purge them from...
by JRodriguez
Thu Sep 03, 2009 7:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: retain duplicates out of hash file
Replies: 16
Views: 9937

Are the values in column B known and an small list? Like Months, Week days, Quater .... If yes then I will be happy to share a trick to de-normalize data that I fetch once in while from my "Bag Of Tricks"


Let us know
by JRodriguez
Tue Sep 01, 2009 2:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating a File Name Dynamically
Replies: 4
Views: 1760

Well ... Well if you really want it, you can generate a file for each row returned from a query using UtilityRunJob . UtilityRunJob allows to call a job from inside another job. Just be very careful with the syntax for parameter/values You will need two small jobs: One to select all rows from the da...
by JRodriguez
Fri Aug 28, 2009 10:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replace all occurance's
Replies: 11
Views: 3200

Skp,

Try with the ereplace function

ereplace(YourInputField ,". ",".")

Regards,


by JRodriguez
Wed Aug 26, 2009 11:55 am
Forum: IBM QualityStage
Topic: Quality job running forever for large chunks of data
Replies: 14
Views: 7709

Just generate frequency info for all columns ...
by JRodriguez
Wed Aug 26, 2009 11:07 am
Forum: IBM QualityStage
Topic: Quality job running forever for large chunks of data
Replies: 14
Views: 7709

Rajeev, Well now I can explain why :P : If you check "don't use match specifcation" the stage will generates frequency data for all columns, if you uncheck the option, a Match specification must be provided and the Match Frequency stage will generate frequency data only for those columns u...
by JRodriguez
Wed Aug 26, 2009 6:24 am
Forum: IBM QualityStage
Topic: Quality job running forever for large chunks of data
Replies: 14
Views: 7709

Rajeev,

Are you passing the columns from the transformer stage? If yes then
set a quick test to find out if the Match Frequency stage is the cause just removed the Match Frequency Stage and see if the job write to the target sequential file ..
by JRodriguez
Tue Aug 25, 2009 12:36 pm
Forum: IBM QualityStage
Topic: Quality job running forever for large chunks of data
Replies: 14
Views: 7709

Great! If the new job do not generate any frequency data, is either that the Maximun Frequency Entry value is empty in the Match Frequency stage or the input columns are not propagated to the output columns (See the mapping page in the output link's properties) Or maybe two different file names? Ple...
by JRodriguez
Tue Aug 25, 2009 11:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Errors stopping services
Replies: 4
Views: 4200

When the error happen? If this is a compiler error .. probably you are trying to compile a code that is causing the problem, could be any non standard C ++ compliant

If this is a runtime error, look for memory leaks or default setting of your compiler
by JRodriguez
Tue Aug 25, 2009 9:31 am
Forum: IBM QualityStage
Topic: Quality job running forever for large chunks of data
Replies: 14
Views: 7709

Rajeev,

Are you generating the frequency info in the same job? If yes then generating the frequency in a previous job will do the trick

If not, please post your job design
by JRodriguez
Mon Aug 24, 2009 10:30 am
Forum: IBM QualityStage
Topic: Quality job running forever for large chunks of data
Replies: 14
Views: 7709

There are design good practices to make a QS job run faster Would you mind telling us more about your job, so poster can provide better suggestions? Below are the most common factors that you could make a QS match (any type) job run slower with bigger data: - System resources .... - Standardizing th...
by JRodriguez
Mon Aug 24, 2009 10:01 am
Forum: IBM QualityStage
Topic: Blocking on exact Name and exact Email
Replies: 2
Views: 2274

Is complaining about a data issue in line 4 ... Check for null values in email (Just guessing that it won't be in the name field)


Would you mind posting the first 5 lines from your input and frecuency file?

How many passes in your Match Specification?
by JRodriguez
Mon Aug 24, 2009 9:51 am
Forum: IBM QualityStage
Topic: Standardization of Chinese address
Replies: 5
Views: 3475

Well .. Either your input data must be translate to Chinese or the rule set should be modified to process Chinese data written in English

There is not ( AFAIK) an out of the box solution for your requirement
by JRodriguez
Wed Aug 19, 2009 12:02 pm
Forum: IBM QualityStage
Topic: Standardizing Indonesian Names
Replies: 4
Views: 2808

shd_sbq, I guess that you will be developing a custom rule set to process Indonesians names. In that case I would used a combination of a classification table with threshold weights values that allows misspelling and the COPY_C ( Copy the closest token) action in the patten action file i.e Classific...
by JRodriguez
Thu Aug 06, 2009 10:21 am
Forum: General
Topic: Execute Command Restartability Issues
Replies: 11
Views: 3168

I'm working with 8.1 and I'm able to restart sequence from the point of failure Do you have a failure trigger by any chance? If your sequence has "Automatically handle activities that fail" property selected then you shouldn't add a failure trigger. Code will be inserted to execute the Exe...