Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
kennyapril
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
Post
by kennyapril »
I have a warning from sequential stage which is capturing rejects from table.
Invalid character conversion found converting to ISO_8859-1:1987, substituting.
please suggest if any changes are required?
Thanks
Regards,
Kenny
-
SURA
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 1229
- Joined: Sat Jul 14, 2007 5:16 am
- Location: Sydney
Post
by SURA »
It seems to be like NLS Map issue.
You need to know about the data!
DS User
-
kennyapril
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
Post
by kennyapril »
Do you mean the metadata coming in?
There are other jobs which are of same kind but they do not show this warning.
Do I need to check the fields and data in it?
Regards,
Kenny
-
kommven
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 125
- Joined: Mon Jul 12, 2004 12:37 pm
Post
by kommven »
Try define Character fields as Unicode and make sure NLS is enabled and supported mapping are defined.
-
kennyapril
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
Post
by kennyapril »
Thanks
Used unicode for all char and varchar fields also checked the NLS settings at project level which says loaded for all maps.
Please suggest what is supported mappings? do you mean the mappings before the sequential file.
Regards,
Kenny