DSXchange

what is the NLS charecter set on the project?

sun786 wrote:what is the NLS charecter set on the project?

we don't have NLS characet in my PROJECT.

What is your source? Is it a flat file or a database table? If a table then, what is the NLS character set in your source database? WHat happens when you write to a text file, do any of the characters show up?

DSguru2B wrote:What is your source? Is it a flat file or a database table? If a table then, what is the NLS character set in your source database? WHat happens when you write to a text file, do any of the characters show up?

Please find the following details:

Source :SQL server
NLS caracter set on sql server :ascii
Target :oracle
NLS caracter set on oracle UTF-8


Thanks &Regards
Srihari

Create a Job parameter NLS_LANG and set the value as AMERICAN_AMERICA.UTF8

Hemant_Kulkarni wrote:Create a Job parameter NLS_LANG and set the value as AMERICAN_AMERICA.UTF8

I created job parameter and assigned AMERICAN_AMERICA.UTF8 value. Even though I get the following error.

"Transformer_2: Pin 2 not initialized"


Could you please provide any resolutions


Thanks

The key is in your NLS_LANG (and probably LC_CTYPE) environment variable setting. In order for the conversion to happen properly, Oracle needs to know the source character set is different from its native character set. Otherwise, everything is moved over unconverted and thus can become invalid in the process. To do this you need to override their values in your job by setting up User Defined Environment Variables in the Administrator and then including and overriding their value in the processing job.

It has been discussed and explained here a number of times, so not about to type it all up again. Searching the site for NLS_LANG and LC_CTYPE should turn up various conversations here, like this one as just one example.