Error loading special chars using oracle enterprise stage

bgs · Post by **bgs** » Thu Feb 18, 2010 11:59 am

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.

DSguru2B · Post by **DSguru2B** » Thu Feb 18, 2010 1:02 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Feb 18, 2010 4:24 pm

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

chulett · Post by **chulett** » Thu Feb 18, 2010 5:22 pm

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.