DSXchange

Please give examples of values into and out of each Transformer stage, indicating whether each example is as expected.

Setting Preserve Partitioning to Clear in the Oracle stages is the cause of this warning. Change it to Default.

But it's dfloat within the Aggregator stage.

Investigate the Decimal Output property and the Preserve Data Type property.

You have to set column#15 first, then column #14, and so on till you get to column #10. And higher-numbered columns must always have "weaker" rules than lower-numbered columns.

The names in the ORCHESTRATE structure must match those in the Columns grid of the stage.

Except for the _IN and _OUT suffixes these are the names of "helper subroutines" on the server that are being invoked through a Subroutine object in the client. The first argument on the _IN calls is typically the driver for a dispatch code within the routine; the first argument in the _OU...

This may be caused by &PH& being created as a "Type 1" rather than a "Type 19". Type 1 imposes an absolute limit of 41 characters, and structures these physically into subdirectories of not more than 14 characters in the name of each. To remedy this permanently execute th...

Click Help while you are in the Columns grid. The explanation there is quite good.

The "next version" does not yet have a version number, for legal reasons. I don't have any details about Balanced Optimizer with me - if you have access to the IOD 2009 or IOD 2010 Europe presentations you can probably get some knowledge about what's planned. Or go to IOD 2010 in Las Vegas...

It's called a (horizontal) pivot, and you can achieve it using a Pivot stage.

Find a UNIX-based ODBC driver for Microsoft Excel and use that.

By not mapping a dfloat (which can be an extremely large number) into an int32 (which can't be bigger than about 2,700 million).

They would. How do they explain the slowness?

Do the project Add and Delete buttons appear or are they, too, disabled? If they (and the NLS button) are disabled, this might indicate that you're opening the Administrator client without being credentialled as a DataStage and QualityStage Administrator.

What do you put in the cases job parameter? Do you escape the quote characters?

Search DSXchange for examples of where DataStage drops quotes from job parameter values, particularly in SQL.