Regarding NLS MAP

srini.dw · Post by **srini.dw** » Fri Apr 18, 2008 8:52 am

Hi,

Loading source data [Sql server] to Teradata as target database. Extracting data from Sql server using Dynamic RDBMS stage. Source containing one description column length as 4000 chars. This column contain data as multiple language values.

NLS MAP ----- Project default (ISO-8859-1)

I am getting below warning.....

APT_CombinedOperatorController(1),0: Invalid character conversion found converting to ISO-8859-1, substituting.

Please guide me resolve this issue.

Thanks,
Srini

ray.wurlod · Post by **ray.wurlod** » Fri Apr 18, 2008 4:09 pm

For starters disable operator combination so you can determine which stage is throwing the error.

Somewhere in your data is a character that does not exist in the ISO8859-1 character map. You will need to monitor your data to determine the row in which this occurs then seek out the unmappable character.

srini.dw · Post by **srini.dw** » Mon Apr 21, 2008 12:49 am

Hi Ray,

I am getting this warning in Transformer stage.

TRNS_FDI_DATA,0: Invalid character conversion found converting to ISO-8859-1, substituting.

Thanks,
Srini

ray.wurlod · Post by **ray.wurlod** » Mon Apr 21, 2008 2:51 am

Search will be your friend.

srini.dw · Post by **srini.dw** » Mon Apr 21, 2008 5:32 am

Before posting this issue i already did search in this forum.

But I didn't find any posts related this issue.

Thanks,
Srini

ray.wurlod · Post by **ray.wurlod** » Mon Apr 21, 2008 4:50 pm

How strange!

I just did a search (exact match) for "Invalid character conversion found converting to ISO-8859-1, substituting" and got 12 matches.