DSXchange

I am trying to load special characters (characters of a different language) into oracle table using oracle enterprise stage. target column is varchar .
I am able to load the record into table but the characters are changed to something else. Is there any setting I have to change so that oracle enterprise stage loads them without changing?
Using user defined update in enterprise stage.

What is the NLS setting in your target? Does it match your datastage NLS setting? Is NLS enabled? Why is the sky blue?

Character mapping must be consistent across all phases of the ETL.

Meaning you need to know the character set of your source and you need to know the characterset of your target and handle any mapping issues appropriately.