Page 1 of 1

Teradata warning from character set to ISO-8859-1may affect

Posted: Wed Jun 20, 2012 8:54 am
by mandyli
I am getting following warning from Teradata connector stage
"Conversion from the ISO_8859-1:1987 character set to ISO-8859-1 may affect performance "


Thanks
Man

Posted: Wed Jun 20, 2012 9:36 am
by jwiles
And your question is?

For the record, ANY conversion may affect performance...it's additional processing

Regards,

Posted: Wed Jun 20, 2012 12:51 pm
by kwwilliams
Set the job to NLS Map ISO-8859-1 and the warning will go away. You will have to type the NLS map manually, it's there but not in the drop down list.

Posted: Thu Oct 04, 2012 2:31 pm
by adityavinay
Williams,
Changing the NLS @job/project level will resolve the issue.
Do you have any idea on why that change is required when both represents same charecter sets.

According to IANA(http://www.iana.org/assignments/character-sets) ISO_8859-1:1987 is Alias to ISO-8859-1

Name: ISO_8859-1:1987 [RFC1345,KXS2]
MIBenum: 4
Source: ECMA registry
Alias: iso-ir-100
Alias: ISO_8859-1
Alias: ISO-8859-1 (preferred MIME name)
Alias: latin1
Alias: l1
Alias: IBM819
Alias: CP819
Alias: csISOLatin1

when both names are representing the same charecter set why this warning occurs? Could some one please explain ?

Thanks,
Vinay.

Posted: Thu Oct 04, 2012 3:30 pm
by ray.wurlod
DataStage issues the alert when any difference occurs in the map name; it is not the responsibility of DataStage to be aware that one map name is an alias for another one.