DSXchange

Tab is usually a safe delimiter character to choose.

This error is not from a Peek stage. You have used a stage type that has a "TARGETTABLE" mandatory property and have not provided a value for this property. The Peek stage does not have such a property. What stage types (precisely) do you use in your job design? Set APT_DUMP_SCORE to True and inspec...

Set the environment variables up as job parameters and use job parameter references in the FTP stage.

In server jobs processing is row by row unless you enable some form of row buffering. Then it is buffer by buffer.

And Wrapped stage. You could create your own Command stage with that!

It doesn't ship but can be had for the asking. It's also handed out on most (all?) of the IBM DataStage training classes in a folder called "OEM Manuals" on the student CD.

The Transformer stage can still output a VarChar, then you use a downstream stage (another Transformer or a Modify stage) to convert the data type. Whether this will conserve the microseconds I am not sure, but it's the approach I'd investigate. My guess is that, if the timestamp format string inclu...

How long does the Oracle query take in another utility, such as sqlplus or TOAD? I don't believe doing the NVL operations in DataStage would be any faster.

If you have Enterprise Edition with parallel jobs licensed you can use the orchdbutil utility to import table definitions accurately.

Server jobs (and therefore hashed files) are fully supported in version 8.0. The principal difference for server job developers is that the repository is no longer stored in hashed files, but in a separate database, which is the unified repository for all IBM Information Server products. Metadata ar...

We don't know that that is the case.

Rows/sec is an almost completely meaningless metric. Various factors influence it, usually negatively, such as row width, network bottlenecks, the clock still running after all rows have been processed, and so on. I have posted before on this. There can be no such thing as an answer to the question ...

I'm sure this has been answered before. Did you do a Search for "microseconds"?

'Objectives" (areas covered) are here and there are some sample questions here

There is a specific ODBC driver for Excel, from Microsoft curiously enough. You can write to an Excel worksheet, but it must already exist and have the column headings in place. Excel treats a worksheet as a system table for some reason only known to the authors of the ODBC driver, and there are res...