Page 1 of 1
sequential file warning
Posted: Mon Sep 12, 2011 1:41 pm
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
Re: sequential file warning
Posted: Mon Sep 12, 2011 5:42 pm
by SURA
It seems to be like NLS Map issue.
You need to know about the data!
DS User
Posted: Tue Sep 13, 2011 8:28 am
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?
Posted: Tue Sep 13, 2011 9:31 am
by kommven
Try define Character fields as Unicode and make sure NLS is enabled and supported mapping are defined.
Posted: Tue Sep 13, 2011 2:32 pm
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.