Search found 53125 matches

by ray.wurlod
Mon Jan 23, 2012 1:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: schema file
Replies: 3
Views: 1148

No they're not. The schema file serves only to describe the record layout. You can perform Aggregations in the Aggregator stage (or some of them in a Transformer stage) but, to do so, you will need to name the output and input columns in that stage explicitly.
by ray.wurlod
Mon Jan 23, 2012 1:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writing to .mdb file via datastage
Replies: 11
Views: 4879

Welcome aboard. When's the interview?
by ray.wurlod
Mon Jan 23, 2012 1:23 am
Forum: General
Topic: Number of Projects/Jobs
Replies: 17
Views: 6676

Code: Select all

dsjob -lprojects
by ray.wurlod
Sun Jan 22, 2012 8:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: need to find if DataStage installed with NLS enabled.
Replies: 6
Views: 2918

Do jobs have an NLS tab in job properties? If yes, NLS is installed and configured (enabled). If no, NLS is either not enabled (NLSMODE=0 in the uvconfig file) or not installed at all (no NLS entries in the uvconfig file).
by ray.wurlod
Sun Jan 22, 2012 12:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Transformer -- Unable to run job --2
Replies: 3
Views: 2435

Lessen the total load on the machine.
by ray.wurlod
Sun Jan 22, 2012 12:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer & Modify
Replies: 3
Views: 1809

In DataStage jobs. :)

The Modify stage is more limited in what it can do, but makes up for that by being very efficient.
by ray.wurlod
Sun Jan 22, 2012 12:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to dived the data int diff targets
Replies: 10
Views: 3764

Are there criteria that specify which rows go to which targets? The stage that splits the rows might be a Filter stage, a Switch stage or a Transformer stage.
by ray.wurlod
Sun Jan 22, 2012 12:15 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: IA reporting with SQL
Replies: 6
Views: 2835

I really should learn the http api. I faced four questions about it in the certification exam.
by ray.wurlod
Sat Jan 21, 2012 3:02 pm
Forum: General
Topic: Extract the datepart from the filename
Replies: 15
Views: 4088

That's just inviting Murphy's Law to kick in!
by ray.wurlod
Fri Jan 20, 2012 12:44 pm
Forum: General
Topic: Problem with viewing DataStage logs in Unix
Replies: 12
Views: 7091

Project names are case sensitive.
by ray.wurlod
Fri Jan 20, 2012 12:41 pm
Forum: General
Topic: Extract the datepart from the filename
Replies: 15
Views: 4088

In the controlling sequence that supplies the file name use an expression using a Field() function.
by ray.wurlod
Fri Jan 20, 2012 12:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compare tables data
Replies: 5
Views: 2201

Don't think so, Craig. The question is counts of matched and non-matched records from a join, but without metadata. This is impossible; even with RCP enabled, at the very least join keys must be specified. There is an approach using upstream Modify stage to generate join key names using job paramete...
by ray.wurlod
Fri Jan 20, 2012 12:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IBM InfoSphere Information Server engine processes
Replies: 9
Views: 3363

Was the new installation specifying the -itag option? If not, you've upgraded the old installation.
by ray.wurlod
Fri Jan 20, 2012 4:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: filepattern - reading list of files
Replies: 18
Views: 6029

I have given with 'cat' in file pattern .. but i'm getting the follow error : Sequential_File_0,0: Couldn't find any files on host SEW06728 with pattern CAT//\ \ H:/DEV_VIF0_EE/TEMP/TEST./*. Do i need to enable /check any option That's what you get for hopping onto the end of someone else's thread....