DSXchange

More likely Windows can't find the sqlcmd executable because its parent directory is not mentioned in your PATH environment variable and you're not executing in its parent directory. You can get around this by specifying the full pathname of the sqlcmd executable.

The upgrade is fairly straightforward, and jobs and sequences will be upgraded as part of it. Details about how to upgrade from version 7.5 can be found in the Installation and Upgrade manual for Information Server, which you have with the version 8.5 software. It's also available from the Informati...

Can you View Data successfully with respect to your source file?

But that's correct! If you're pulling NULL from SAP and inserting untransformed data into Oracle, then you should expect to see NULL in Oracle. You can't trim NULL (at least not till version 8.5). To detect NULL, therefore, you need to apply the IsNull() function to the original input column, as MT ...

How are you partitioning the data?

"Sort method" is how you are asking the Aggregator stage to work (and requires that the incoming data are sorted).

You can not remove duplicates without either sorting or joining the source to itself.

Probably not using UTF-8 (though you may be lucky). Try using the appropriate Chinese character map (for example GB2312 or BIG5).

(1) Only by designing that functionality into your job.
(2) From the beginning, unless designed otherwise.
(3) See (1).
(4) It seems you need some kind of "vertical pivot" in this case. Yes it can be done. Search DSXchange for examples.

Sort the data upstream of the Transformer stage using a Sort stage which also generates a Key Change column. Then, within the Transformer stage, use the value of this Key Change column in constraint expressions to capture unique values and duplicates onto separate output links.

Study one of the productivity aids in the Transformer stage, namely Derivation Substitution.

soumya5891 wrote:It is better to use hash partition whenever you are working on group of data like aggregator,sort,remove duplicate.

That's not always true. For example, if the grouping key is an integer of some kind, then Modulus should be preferred, as it's more efficient than Hash.

Are you reading or writing this file?

I'm sure I specified "cycle with one value" earlier.

Whenever you extract that field from the database use any null handling function like COALESCE function because it may happen that database null does not match with data stage null Do you have any proof of this? Over the last 13 years I've found DataStage null handling to be quite reliable, no matt...

You shouldn't need a configuration file for server edition. Assuming, therefore, that you're using enterprise edition, the error is in TCP and described by exit status (error code) 111 - connection refused. Therefore we must conclude that, in spite of your assertions, communication between the machi...