DSXchange

There is no certification available for DataStage Server Edition.

The Data Warehouse Institute (TDWI) offer some certifications; search this forum or their website for more information on that.

Welcome aboard.

Questions about server jobs belong in the Server Edition forum.

It's easier (and legal) simply to add an extra column to the link between these stages, and load your value into that.

sachin1 wrote:A hash file can simply be described as a file that distributes data throughout a pre-sized and space allocated file.

No, that's a hashed file that you've defined.

sachin1 wrote:A hash file can simply be described as a file that distributes data throughout a pre-sized and space allocated file.

No, that's a hashed file that you've defined.

As for the octal numbers, type in man chmod at the UNIX prompt.

If you would re-phrase your last post in English, so that I can understand it, then I might be able to offer some cogent advice. I do not understand your post as it is written. DSXchange is NOT a mobile telephone.

Before embarking on week manipulation you need to get your business rules right for week number. How is week #1 defined? Take a look at the WeekTag routine (category Examples\Functions) to see what I mean; their rule is documented in comments at the top of the code. Of course this is for a calendar ...

I like to think of it as this: Modify stage can create, using a limited set of functions, a new record schema that is based upon the columns on its input.

No. All you get from Director is the time. The MB is external to DataStage. You have to do some arithmetic. If that's too hard, get Excel to do it for you.

It is sometimes necessary, with NLS enabled, to handle characters that are not ordinarily trimmable, such as the Japanese space character. You can write a routine but it is much easier to add the code point for this character to the TRIMMABLE class in the CTYPE category of the NLS locale.

chulett wrote:

ramasubba wrote:seq->tr->seq - compile & run successfully

The assumption here is the compiler must be both installed and configured. Rayo-san.

Ah. Yeah.

Some of the participants here on DSXchange are clearly certifiable.

Megabytes per minute is a better rate metric, as it is not influenced by row size. However, it remains a problem that startup times and other wait times are still counted, and that - for some reports - the time is rounded to whole seconds.

Yes.