DSXchange

I searched through the forum but could not find an answer.

I get the warning:

main_program: The NLS character map <ASCL_MS1252> specified may not be compatible with the character set specified by NLS_LANG;
you may get unexpected results from your database.

My settings are:

1)Character set specified by NLS_LANG: American_America.WE8ISO8859P1

2)Oracle Database NLS_LANGUAGE value: AMERICAN
in NLS_DATABASE_PARAMETERS and NLS_SESSION_PARAMETERS

3)On the target Oracle stage:
Select category to set map for: NCHAR/NVARCHAR2
Map name for 'NCHAR/NVARCHAR2': Project deault (ASCL_MS1252)

So, are you really dealing with NCHAR / NVARCHAR2 data? What is your source?

No I am not. My source datatypes are regular data types such as Varchar2, Decimal, Bigint etc. I should probably select "Other Types".

Check the character set in your data base side.

use:

select * from nls_database_parameters where parameter='NLS_CHARACTERSET'

also check your DS Director log. Especially the second log which has the environmental settings: Check the NLS.

It is:
WE8ISO8859P1

What's interesting is, it happens in one environment but doesn't happen in another. I thoroughly checked both environments and the settings look exactly the same.