RE: How can I load my data having special characters into target without change data

My Source file having data with special characters (e.g Ñ) and i try to load into avro target, it was not loading properly.

WilliamS Beginner Asked on December 10, 2019 in Diyotta Studio.
Add Comment
1 Answers

Hi William,

In order to load special character data into the AVRO target, Diyotta provides you a provision of using the Reader/Writer Encoding options

in the load/extract properties using which we can load the special characters into the target.

Source Data:

RE: How can I load my data having special characters into target without change data

 

We need to choose the below Load/Extract properties in the dataflow. In the extraction properties, we need to select Reader Encoder: ISO-8859-1

and in Target load properties, we need to choose Writer Encoder: ISO-8859-1.

Extract Properties:

RE: How can I load my data having special characters into target without change data

Load Properties

RE: How can I load my data having special characters into target without change data

 

Target Data:

RE: How can I load my data having special characters into target without change data

 

 

Expert Answered on December 13, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.