How to address encoding issues and encoding conversions with informatica Data Transfromation and PowerCenter ?

DWQA Questions › How to address encoding issues and encoding conversions with informatica Data Transfromation and PowerCenter ?
0 Vote Up Vote Down
A.B Link Consulting Team Staff asked 10 years ago

Hi All, I am using Informatica Data Transformation for XML handling . My source XML file is ISO-8859 encoded (contains some special characters like รข ). The output file created in DT needs to be UTF-8 encoded.In the mapping I created, The output of my DT transformation, and as a result , my PowerCenter mapping is corrupted, and in the PowerCenter output file I can not see well encoded UTF-8 data. Any idea how to fix this in Informatica , and how to execute the encoding conversion ?

1 Answers
0 Vote Up Vote Down
A.B Link Consulting Team Staff answered 10 years ago

Hi! DT can act as a flexible encoding conversion tool in your integration . it offers built in encoding conversion functionality, with a wide range of encoding options.

Steps for define encoding in DT :

  • In DT studio go to properties encoding and change input encoding encoding according the source file real encoding (in your case iso-8859)
  • The most popular encoding is UTF that cove the most languages.
  • Change the output encoding to your desired output encoding (in your case utf-8)
  • The working encoding is the encoding which you prefer to work with in the DT studio.