Informatica Q&A › How to address encoding issues and encoding conversions with informatica Data Transfromation and PowerCenter ?
<Guest>
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 ?
<ABlinkconsulting>
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.
