Hi,
Thanks for your reply,
I have checked the Oracle DB having NLS settings as like below
"Select * from nls_database_parameters"
NLS_CHARACTERSET AL32UTF8
The characters were not displaying even when the data has been viewed from Oracle enterprise stage it self.
it would be more helpful if we get this issue resolved.
NLS Details in Datastage
----------------------------
NLS section of DS Admin
********************
In project level it is ISO8859-1
DataStage
*********
Default map for stages: UTF-8
Default collation locale for stages: Project (OFF)
NLS Map tab of Oracle Enterprise Stage:
********************************
Select category to set map for: NCHAR/NVARCHAR2
Map name for 'NCHAR/NVARCHAR2': Project default (UTF-8)
In oracle DB
----------------
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 -10.2.0.4.0