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,