DSXchange

you will need to install Progress client (networking) and also the odbc driver.

The ODBC driver for Postgres should work. You will need to test it either by doing a metadata import or through the command line tools provided.

I would not use a CRC32 algorithm as your "natural" key. Instead I would use a Surrogate/sequence generator as the key to ensure uniqueness.

you'll need to setup a connection to that database (ODBC, etc).

I would refer you to the DataStage developer's manual. Hash Files are not a very difficult concept.

ODBC is the method by which to accesses a Progress database. As far as I know it supports SQL-92 so you should be ok.

We have had this problem in the past and Python will accurately encode and decode the Japanese UTF-8 characters. This is done in a pre-load process either called by a batch or unix shell script. The link above actually has a working UTF8 conversion program and how to implement it.

Like MetaStage, QualityStage, etc. It's a separate product. I don't know if it's included in DataStage Enterprise or not.

What was the job doing when it Abnormally terminated?

Did the process core dump?

Did you try running ps -aux while the job is running to see if it's leaking memory?

(snip) "SSN made an error, and now I have to correct it in my dimesion table" SSN is your primary key. In a normal dimension this would be a surrogate (sequence) key. The short method to update this is to disable/drop your primary constraint, update the row manually and the recreate your p...

You need to "join" the hash file stage into the transformer and link the key columns. This is covered in the documentation.

This can be nicely done by writing a Python script to handle the decoding and encoding of the data. DataStage is a data migration tool and is not really designed for this type of encoding/decoding. By writing a script in Python you can ensure that it is platform neutral. See: http://www.opendocspubl...

What is the data type of CWBNL0107 and are you using a Transformer. If so, what is the Transformer's datatype of this object in the target.

[IBM][Client Access Express ODBC Driver (32-bit)]
Column 5: CWBNL0107 - Converted 50 bytes, 49 errors found

You should be able to get these from Ascential software's eServices site with your login id.

If your oracle target is OCI, the date needs to be in it's native format which in the generated SQL code will use a to_date conversion function.