sequential file warning

kennyapril · Post by **kennyapril** » Mon Sep 12, 2011 1:41 pm

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

SURA · Post by **SURA** » Mon Sep 12, 2011 5:42 pm

It seems to be like NLS Map issue.

You need to know about the data!

DS User

kennyapril · Post by **kennyapril** » Tue Sep 13, 2011 8:28 am

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?

kommven · Post by **kommven** » Tue Sep 13, 2011 9:31 am

Try define Character fields as Unicode and make sure NLS is enabled and supported mapping are defined.

kennyapril · Post by **kennyapril** » Tue Sep 13, 2011 2:32 pm

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.

DSXchange

sequential file warning

sequential file warning

Re: sequential file warning