DSXchange

Please confirm:
(a) the names of your grouping columns
(b) the names of your hash key columns
(c) the names of your sort key columns
(d) the Aggregator operation method (hash or sort)

Due to lack, one blogger was saying IOD = ice-cream on demand

On Wednesday there WAS ice cream!

No conversion is required. Or, to put it another way, it's automatic: if you use the value in a string context, then it will be a string.

Numeric(17,1) can only have 16 digits to the left of the decimal point.

Get a premium membership so that you can read the entirety of my post.

Then you didn't do it right.

If $APT_DISABLE_COMBINATION is True, then it is impossible that APT_CombinedOperatorController operators can be generated.

We don't do "urgent". DSXchange is an all-volunteer site whose members post as and when they can. Being asked for urgent response is, frankly, offensive. If you want urgent help, sign up with your official support provider for priority service, and learn just how much "urgent" c...

A File Set will always be slower than a Data Set. File Set uses export and import operator, while Data Set uses copy operator. The slowness loading the Oracle table is something in Oracle. You can prove this by constraining the rows to pass zero rows to Oracle, thereby getting a measure of the raw r...

Or an Open command in the Oracle Enterprise stage.

All calculation inside the Aggregator stage are performed as dfloat. Your design specifies an output column as integer data type. This generates the alert messages, because not all dfloat numbers can be stored as integer. Use the DecimalOutput property or Preserve Data Type property to avoid this al...

fileset is partioned and stores the data in ascci format unlike the sequential file stage. file stage stores the data in human redable format unlike the filedet This is incorrect. The File Set also stores the data in human readable format. File Set is partitioned, with data file(s) on the resource ...

This has nothing whatever to do with your data containing Chinese characters. These messages alert you to the fact that somewhere in your job design to a transition from a variable length ustring to a string, and another in the reverse direction. Track down where string is used in the metadata and c...

My guess is that the configuration file is missing the final right brace character ( } ) or that the final line in the configuration is not terminated with a regular end-of-line terminator.

Was the configuration file created using the Configurations editor GUI or using a text editor?

And you will also need to purchase a third party UNIX-based ODBC driver for Unidata - none ships with DataStage.

An easier approach would be to embed a Unidata stage in a server shared container and to incorporate the same in your parallel job.