Hello All,
I am moving data from one Oracle database to another. My flow is like this:
ExecuteSQL -> SplitAvro -> ConvertRecord ( to generate SQL statement) -> ConvertCharacterSet ( UTF-8 to ISO-8859-1) -> PutSQL
Source oracle DB has character set AL32UTF8
Target oracle DB has character set WE8ISO8859P1
But I see lots of ?? in the target database. Any clues on what I am doing wrong here?
P.S : My flow runs slow as I am not using prepared statement. I will work on this once this character set issue is resolved.
Thanks in advance !!