Data Serives XI 3.2 Special Character issue

117 Views

Hello ALL,

Issue: Using Data Services XI 3.2 for the ETL purpose in which European character data for example phi symbol
load into target system as question mark(?).

The details are following of source and target system:

Source:Oracle with character set WE8DEC

Target:Oracle with character set UTF-8

I have tried the following steps:

1. Change the setting of datastore leve by changing the code and server level to UTF-8 in the datastore settings.

2. Implemented the option at the target table to support NVARCHAR

The above steps are implemented but not worked.

When I preview the data of the source table it shows correct European characters but when I run the job
the final table contains question mark symbol instead of European characters.

Could someone look into this?

Thanks & Regards,
Yogesh Verma