DSXchange

Monitor scratch disk during execution, not before or after.

I think it's clear from the original post that it's none.

Design, write C++ routines, compile, link and test them without involving DataStage. In DataStage create new "parallel routines", which are entries in the Repository showing the location and number and type of arguments for your functions. Within a Transformer stage, call your routines from the DS R...

What if the incoming field is a Date data type?

Incidentally, it's not U (one of our occasional posters) who is having this issue, it's meet_deb85. The correct spelling of the second person personal pronoun is "you".

Not directly. There's no lookahead capability within the flow in DataStage. You can use stage variables in a Transformer stage to detect the first record in a group, then sort by the group keys then by that value in descending order, and then detect when that"key change column" was 1 in the previous...

As noted elsewhere, you do NOT hijack threads. Hijacking a resolved thread on a completely unrelated topic is totally counterproductive - it doesn't help you and it doesn't help future searchers. There is a button captioned "Post new topic" on the left of the button bar. Use it. That way we will kn...

Show (by posting it) that there is an entry for CRMK in uvodbc.config. Show that there is a proper DSN defined for CRMK. Show that the entries can be resolved in tnsnames.ora.

And if you can't answer those questions, you can't read the file.

You should generate a file with these characteristics. Use a fixed-width format (so you know where each field begins and ends) and/or use a line terminator.

January through September, and the first nine days of each month.

I've just noticed that the job is designated as a server job. In that case the solution is easy.

Investigate the "rows per transaction" property of the ODBC stage.

Investigate the "rows per transaction" property of the ODBC stage.

Is this the same project as this post?
Leading zeroes are merely an artifact - they do not matter for data type Decimal.

Firstly is the data type of your input field Date or some kind of string? Secondly, is it always a single digit for month and day, as the format string you've specified suggests? Only then can you start worrying about manipulating formats. Essentially you will need to convert to a string so you can ...

Look at the VOC entry for ExecSH both in the project where it does not work and in one where it does.

The best place to learn about the design of slowly changing dimensions is in a book such as Data Warehouse Life Cycle and Toolkit by Ralph Kimball and others. Once you understand what needs to be done designing the algorithm is straightforward. It's even easier when you get version 8 with its Slowly...