DSXchange

Is it really being converted, or is it simply a deficiency in the data viewer?

That is, is the registered trade mark character successfully being processed into your target? DO NOT rely on what the Data Browser is showing you - it is quite limited in the characters that it can display.

If you are seeing these special characters as '?' in your target table/file (don't use DataStage data viewer to validate.), then try changing NLS settings (try AMERICAN_AMERICA.AL32UTF8 or AMERICAN_AMERICA.WE8PC850 or NLS of your database)