Reading junk characters from Oracle 11g

sgubba · Post by **sgubba** » Sun Jul 26, 2009 8:13 pm

Hi,

i have a problem reading data from oracle table which is 11g. I am able to load the table with out any problem using ODBC stage. I use ASCL_ISO8859-1 character set when i am loading and have no issues . But when i am using the same character set i read them as junk characters.
This is the character set of my target database

NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 11.1.0.7.0

Your help is highly appreciated

Thanks

ray.wurlod · Post by **ray.wurlod** » Sun Jul 26, 2009 11:40 pm

And what are your DataStage NLS settings?

ArndW · Post by **ArndW** » Mon Jul 27, 2009 12:58 am

In addition to what Ray has said, how are you determining that the characters read in a "junk" (hint: don't use "View Data" to determine this)?

sgubba · Post by **sgubba** » Tue Aug 04, 2009 9:28 am

I tried using UTF-8 while loading and reading. The job i am trying to run has a change capture stage where one source is oracle and the other is ODBC. Its kinda reconciliation job,

Fisrt job is loading from oracle 10g(source) to 11g(Target) when i am loading into target i use ODBC.

In my reconcilation job i has this change capture stage where one source is oracle 10g and other is oracle 11g. I didnt had any problem loading the data into 11g(ODBC Stage) . When i am reading from ODBC I have issues...

chulett · Post by **chulett** » Tue Aug 04, 2009 10:29 am

Perhaps you could be a little more specific as to the "issues" you are seeing. Examples are good, too.

sgubba · Post by **sgubba** » Tue Aug 04, 2009 1:52 pm

Issues in the sense. I know the data from source and target are the same but in my chance capture stage they are not matching ....and all the records are comming out as inserts.....I tried to view th data in ODBC stage and its throwing junk data