DSXchange

As the principal requirement you have to give IBM crores of rupees to obtain a legal Enterprise Edition licence.

It's possible, but likely to be inefficient. But first ask yourself whether collection is even necessary at all.

1) This is entirely under control of the framework, unless you override its default behaviour, for example by preventing operator combination via the APT_DISABLE_COMBINATION environment variable. 2) It depends on the stage type but most use "Round Robin" so, for three nodes, you should get 1/3 of th...

What is the setting of NLS_LANG?

XML Input and XML Output are stages that map XML documents to and from rows and columns, respectively. Refer to XML PACK Designer Guide for more information. I have found no mention of XML Reader and XML Writer in the standard manuals. You have specified a server job yet posted in the parallel job f...

DataStage is an ETL tool. It is NOT a metadata manipulation tool. Get MetaStage if you want to play with metadata.

The clock starts running as soon as the job starts. Downstream in the job the rows/sec figures are penalized by the waiting time for the first rows to arrive. Curiously, using large buffer sizes can make this worse, since the time to fill the buffers to their first drain percentage is elevated. What...

The output depends on your "failed lookup" rule. Sounds like you are using Continue. In this case, the failed lookup link's columns are all set to NULL. This may be further affected by whether the receiving link's column definition specifies nullable or not and, where applicable, what its Null Field...

SQLSTATE is only relevant to ODBC connectivity. It is the general-purpose ODBC driver error/warning code. It is usually too vague to be useful.

:idea:
You can disable the "cool" smiley and get Char(8) working right by checking "Disable Smilies in this post" at the bottom.

With such a small number of rows I'd be inclined to use a server job with a Merge stage. If you must use a parallel job, be aware that the Join and Merge stages both require sorted input (added overhead). A Lookup stage would be preferable.

Handle the null explicitly within the expression. Use (there may even be a NullToZero function; I'm working from memory here).

The "-" in front of the timestamp looks ominous, especially since this looks like a retrieval of the system time. (Why do you work so late?!!) Sounds like you've uncovered a bug. Is it reproducible after rebooting the client window (also known as "the Microsoft solution")? If so, report it to your s...

I wonder if that's documented anywhere?

The files that make up your Lookup File Set reside on your resource disk.