Search found 53125 matches

by ray.wurlod
Thu Dec 31, 2009 1:17 pm
Forum: General
Topic: Change Data Capture
Replies: 5
Views: 3094

Welcome aboard. Are you the original poster under a new ID, someone else on the same project, or just a newbie? Scraping the transaction logs (redo) requires less maintenance and ought to provide better performance, because the transaction logs are always there (unless logging is disabled, which is ...
by ray.wurlod
Thu Dec 31, 2009 2:25 am
Forum: General
Topic: uv -admin -info - Disabling Underlining
Replies: 1
Views: 710

uv -admin -info - Disabling Underlining

When the command uv -admin -info is used on some UNIX systems, underlining may be left in effect on the console.

To reinstate to no-underlining, try one of the following commands.
  • stty sane

    ^Jreset^J
where ^J represents Ctrl-J
by ray.wurlod
Thu Dec 31, 2009 12:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: populating date dimension
Replies: 6
Views: 1658

Give a bit more thought to what might be useful things to have, given your day granularity. For example: first day of current month last day of current month year number financial year weekday name weekday number in week ordinal day number in calendar year ordinal day number in financial year season...
by ray.wurlod
Wed Dec 30, 2009 11:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Configuration
Replies: 10
Views: 4514

If you're going to make any use of any aspect of the configuration (for example node pools) in your job design, then best practice is to include $APT_CONFIG_FILE as a job parameter.

It should not be thus, and is probably a bug, but you already have the workaround.
by ray.wurlod
Wed Dec 30, 2009 7:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Configuration
Replies: 10
Views: 4514

So what do you need to know? Is the default configuration not appropriate for your site? In what way(s) is is not appropriate - that is, what configuration do you wish to perform? Open the Data Set Management tool from the Tools menu in either Designer or Director client, identify that default confi...
by ray.wurlod
Wed Dec 30, 2009 7:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Configuration
Replies: 10
Views: 4514

That is the default configuration file for the whole project.
by ray.wurlod
Wed Dec 30, 2009 7:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Configuration
Replies: 10
Views: 4514

Open the Administrator client. Select your project then select Properties. On the General tab click Environment button. Choose the Parallel folder. Report the currently-set value of APT_CONFIG_FILE environment variable. Verify (on the server machine) that this file exists.
by ray.wurlod
Wed Dec 30, 2009 4:42 pm
Forum: IBM QualityStage
Topic: Generate Match Designer Report
Replies: 4
Views: 2036

What do you think would be IN a Match Designer report?

(I don't think one is possible, but the blocks of potential duplicate records can be sent to a file.)
by ray.wurlod
Wed Dec 30, 2009 4:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Clearing Data Flow Indicators
Replies: 0
Views: 956

Clearing Data Flow Indicators

Does anyone know how to clear the yellow link markers caused by effecting a "Show where data originates from" or "Show where data flows to" analysis, without needing to resort to closing and re-opening the job? (Repository > Refresh does not clear these markers. Recompiling the j...
by ray.wurlod
Wed Dec 30, 2009 3:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Web services
Replies: 2
Views: 950

Moderator: please move to Enterprise Edition forum
by ray.wurlod
Wed Dec 30, 2009 3:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NLS button in Administrator greyed out
Replies: 10
Views: 4549

Congratulations for discovering the solution. To my mind it is a bug, because it does not appear to be documented as a requirement.
by ray.wurlod
Wed Dec 30, 2009 3:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to change the job create by another user.
Replies: 3
Views: 1420

Yes, because the problem may be something else, such as some clown actually changing the permissions and getting it wrong.
by ray.wurlod
Wed Dec 30, 2009 2:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merge stage
Replies: 3
Views: 1344

Moderator: please move to Enterprise Edition forum
by ray.wurlod
Wed Dec 30, 2009 2:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merge stage
Replies: 3
Views: 1344

It may not be possible with Merge stage, for at least two reasons. One is that, if there is more than one Update input to the Merge stage, every Update input must be de-duplicated. Another is that rows from the Update links are consumed as they are used.
by ray.wurlod
Wed Dec 30, 2009 2:55 pm
Forum: General
Topic: which process is faster
Replies: 2
Views: 959

The answer for version 6 may be different from answers in later versions, particularly 7.5 in which the vendor did a lot of performance-related work within the product.

Probably fastest in your case is not one of the options you indicated, and that is an entirely Oracle-based solution.