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.