CASS - Latin 1/9 values handling in Address

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
siva.dwhbi
Participant
Posts: 7
Joined: Tue Aug 23, 2011 11:39 am
Location: Chennai

CASS - Latin 1/9 values handling in Address

Post by siva.dwhbi »

Hi All,

Is there any specific setting available in CASS stage to process Latin 1/9 characters in Address field?

When we try to load the latin 1/9 data through CASS, it produces Junk values, instead of Latin characters.

Please let me know, if any one have pointers.

Thanks in Advance!!
Sivakumar Ganesan
-----------------------
Chennai, TN,India
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What is the NLS map setting for your DataStage/QualityStage job?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
siva.dwhbi
Participant
Posts: 7
Joined: Tue Aug 23, 2011 11:39 am
Location: Chennai

Post by siva.dwhbi »

Job level NLS setting - ISO88591
Sivakumar Ganesan
-----------------------
Chennai, TN,India
siva.dwhbi
Participant
Posts: 7
Joined: Tue Aug 23, 2011 11:39 am
Location: Chennai

Post by siva.dwhbi »

I changed the job's NLS Setting to UTF-8. It is working fine and able to process latin-9 characters.

let me know, if any other options available..

Thanks,
Sivakumar Ganesan
-----------------------
Chennai, TN,India
Post Reply