There are actually 2 queries:
1. We have a set of server jobs which we need to have UTF8 enabled for Japanese / Korean characters. These jobs do a lot of lookups using Xformers. Now, the same lookup does not work for Japanese characters even though the job default character set is UTF8 and lookup field NLS map is individually set as UTF8. The lookup field is VARCHAR and has only Japanese characters as of now, though this may not be the case always. 0 records are read from the lookup file.
The same works in a parallel job using a lookup stage. Could anyone throw some light on this?
2. Also, on a related note, we are having a routine which does some comparisons and works fine on Latin characters (input is character). However Japanese characters are not processed correctly. What can be changed in the routine to make it UTF8 compliant?
Lookup fails for Japanese data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 82
- Joined: Wed Jul 14, 2004 7:21 am
- Location: India
Lookup fails for Japanese data
Integrity is what you do when no one is watching
-
- Participant
- Posts: 82
- Joined: Wed Jul 14, 2004 7:21 am
- Location: India
SOlved: Error in mapping hash files
There was an error in hash file mapping - the input and output field columns order was different, hence the problem.
BTW, is a hash file not like a dataset wherein even if you interchange the column names it picks up the correct data? If a hash file is stored as a table internally, then column name order should not matter. That does not seem to be the case.
BTW, is a hash file not like a dataset wherein even if you interchange the column names it picks up the correct data? If a hash file is stored as a table internally, then column name order should not matter. That does not seem to be the case.
Integrity is what you do when no one is watching
definitly not the case with hash files
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org