UTF-8 Data Detected

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
saadmirza
Participant
Posts: 76
Joined: Tue Mar 29, 2005 2:57 am

UTF-8 Data Detected

Post by saadmirza »

Hi All,
I have a DS Server job with Oracle as source and BW Load pack as target. The same job runs without any warnings and loads data inot BW InfoObject succefuly uin D and Q environment. My D and Q runs on the same server but my P runs on a dfferent machine. This warning occurs only when loading data into BW. My project default NLS is MS-1252.
Whn I change the BW Load pack NLS setting to UTF-8 the data appears in BW InfoObject. What may be the reason for occuring in Production server.
I have never seen this warning before.
Please advice.

Thanks and regards,
SM
clarcombe
Premium Member
Premium Member
Posts: 515
Joined: Wed Jun 08, 2005 9:54 am
Location: Europe

Post by clarcombe »

One thing you might look at is the version and configuration of Oracle on the production and development server.

I believe there may be a setting which deals with UTF-8 data.
Colin Larcombe
-------------------

Certified IBM Infosphere Datastage Developer
Post Reply