Page 1 of 1

Reading Japaneese data by ETL

Posted: Sat Apr 14, 2007 6:22 am
by Roopanwita
In our project we have data source in japaneese language.we are not able to read records properly.Can anybody tell how this problem can be resolved. Also Please let us know, is there any way to read the japanese data from source & load it to target table in Japanese.

Posted: Sat Apr 14, 2007 3:24 pm
by ray.wurlod
You must have NLS installed and enabled.

You must be aware of how the Japanese characters are encoded - there are at least fifteen different ways.

This map (for example one of the SHIFT-JIS maps) must have been loaded - use the Administrator client to get maps loaded.

Then you set this map on the stage that is reading from source and the stage that is writing to target.

The maps convert from the external encoding (whatever it is) to a UV-UTF8 encoding of Unicode used within DataStage.

There is a DataStage NLS manual among your documentation that will help you through the various processes. Manuals and readme files are also available in Japanese.