Search found 38 matches

by josh.guffey
Fri Nov 25, 2011 7:48 am
Forum: General
Topic: Validating jobs
Replies: 3
Views: 1348

Thanks for the reply. I agree -- a way to test this would be to create a copy of that sequence and manually set each job activity to "Validate". I was hoping that there was a "Validate, then run" option like the "reset if required, then run".

Thanks again!
by josh.guffey
Wed Nov 23, 2011 1:31 pm
Forum: General
Topic: Validating jobs
Replies: 3
Views: 1348

Validating jobs

Hi Everyone, A team member ran into an issue where they had a Sequence defined that called 20 or so parallel jobs. One of the job activities in the sequence accidentall had an incorrect database connetion parameter defined and subsquently caused the underlying parallel job to fail. I was reading up ...
by josh.guffey
Mon Dec 06, 2010 5:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Composite Key Duplicate Check
Replies: 3
Views: 4676

Composite Key Duplicate Check

Hi Everyone, I have a small table with a 3 data element composite key. My requirement is to check for duplicates within this composite key. Here is the approach that I am taking. Create a derived column D in a transformer that holds the values of these fields by using this logic. If IsNotNull(Src.A)...
by josh.guffey
Tue Oct 19, 2010 2:59 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Information Analyzer Report
Replies: 1
Views: 2009

Information Analyzer Report

Hi Everyone, In the Information Analyzer reporting section of the web console there are reports under the column frequency section for Most Frequent Formats and Most Frequent Values. Does anyone know if there are reports that display Least Frequent Formats and Least Frequent Values? I would like to ...
by josh.guffey
Fri Oct 15, 2010 12:07 pm
Forum: General
Topic: Information Server Blueprint Director
Replies: 6
Views: 3420

Thanks for the feedback Ernie, definitely appreciate the insight.

Josh
by josh.guffey
Thu Oct 14, 2010 11:43 am
Forum: General
Topic: Information Server Blueprint Director
Replies: 6
Views: 3420

Information Server Blueprint Director

Hi Everyone,

I have heard rumors that the new Blueprint Director product will be a free product included in the release of IBM InfoSphere Information Server 8.5 as a part of the foundation tools. Can anyone confirm this rumor or provide comments?

Thanks,

Josh
by josh.guffey
Tue Jul 20, 2010 12:37 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Reference Table Question
Replies: 2
Views: 2399

I do not disagree, I was just curious as to if anyone knew of a faster method. Thanks for the comment.

Josh
by josh.guffey
Tue Jul 13, 2010 2:17 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Reference Table Question
Replies: 2
Views: 2399

Reference Table Question

Hi Everyone, I have been working with Information Analyzer today and I was researching a way to take the reference tables that I create inside of IA and use that data by ETL processes in DataStage (via lookup or join). I know that I can go to the Investigate menu and then select Table Management to ...
by josh.guffey
Mon Jul 12, 2010 9:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX Books
Replies: 4
Views: 2523

You can also read what IBM has published in their various Redbooks.

http://www.redbooks.ibm.com/Redbooks.nsf/portals/data
by josh.guffey
Thu Jul 01, 2010 11:42 am
Forum: IBM QualityStage
Topic: standardize error
Replies: 10
Views: 12573

Rahul,

If memory serves me correct, you should be able to right click on the rule set and select provision all.

Josh
by josh.guffey
Wed May 12, 2010 12:41 pm
Forum: IBM QualityStage
Topic: Standardization of vehicle make and model
Replies: 6
Views: 3669

I do not know of a particular rule set for vehicle makes and models. You can definitely create your own custom pattern action language to handle any data set, but you first have to understand all of the data patterns and tokens that exist within the data that you wish to apply the rules to. I would ...
by josh.guffey
Wed Mar 17, 2010 8:48 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Filter or remove Schemas from Information Analyzer
Replies: 1
Views: 2575

Thanks for the reply Craig. Unfortunately that was not a typo. The crazy thing is that this is only 1 out of about 30 instances...
by josh.guffey
Tue Dec 29, 2009 9:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Comment Job Activity in Job Sequence
Replies: 3
Views: 2114

Thanks Plagvreugd for the suggestion on modifying the execution action. I decided to go that route, as it was the quickest solution. Our group has a best practice of utilizing a UserVariable stage in which we can set/modify many parameters in our sub processes and parallel jobs and I can see how I c...
by josh.guffey
Mon Dec 28, 2009 1:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Comment Job Activity in Job Sequence
Replies: 3
Views: 2114

Comment Job Activity in Job Sequence

Hi Everyone, Is there a way to comment job activities within a job sequence? I have a requirement to turn jobs "off" and I know the customer will want them turned back on at some point in the future. I can of course export the files and save them or just simply remove the job activities, b...
by josh.guffey
Mon Mar 16, 2009 7:36 am
Forum: General
Topic: Training question
Replies: 3
Views: 2979

Training question

Our company is currently in the need of formal training for Information Analyzer, Quality Stage (Essentials and Advanced), Business Glossary (Set up and usage) and MetaData Workbench. We have currently enrolled some of our folks in two of IBMs classes, but they were subsequently cancelled due to low...