DSXchange

*Topic Relocated - Content Editor*

Yes, provided that you can get a keyboard that can spell.

depualf.apt is not the right name!

Are you opening "IBM Information Server console" or "Web console for Information Server"? The first is for Information Analyzer and Information Services Director - my guess is you've opened that and are seeking to create an Information Analyzer project. Please confirm.

Which window (tab) are you on?

DataStage projects are created with the DataStage Administrator client, not with Web Console for Information Server.

It does NOT say error opening directory.

It says error opening dictionary - a completely different can of worms.

Has someone deleted or changed the permissions on D_RT_LOG file?

*Topic Relocated - Content Editor*

The parallel Merge stage and the server Merge stage are two completely different beasts. The server Merge stage should probably be called FileJoin (because it joins two sequential files)

Just out of curiosity, how fast does the UNIX sort command sort this volume of data? Do you have any third-party sort utilities, such as SyncSort or CoSort, available?

Welcome aboard.

There's nothing "out of the box" but, if you know the required format of these files, it should be a straightforward matter to have DataStage construct them.

Look at the log. Checkpoints occur when an activity completes successfully. Therefore, if A completed successfully, it will be checkpointed. On the next run of the sequence (after D fails), A will be skipped. B and C will not be skipped, because this is what "do not checkpoint run" means.

As soon as you come up with a solution to the bimodal problem "they" will provide data with three or more modes. And so it will go. Murphy is alive and well.

Whose requirement?

Would they expect you to tune their car using only a hammer and a whisk broom?

Resist stupid requirements!

Use the right tool for the job.

Use a database or reporting tool that can do nonparametric statistics. This is NOT the province of an ETL tool. You could do mode with a pair of Aggregator stages (count in the first, max in the second) but that would only be appropriate if you could guarantee unimodal distribution. Rank is really a...