how to pass unrecognized special characters from one table to another table using Tmap

[Anonymous]

Hi Team, 

I have couple of records with 'unrecognized special characters' and  want to pass these records into oracle tables from one source table to staging table.

But while load record from source table to stage table records are not coming with 'unrecognized special characters' 

I have address column in source table value is 'sum 2' while loading into stage table using tmap, it's loaded with record value is 'suma 2'

However, I don't want drop any unrecognized special character from source table to target table.

can you please help, how to pass full record with special character coming at last position in record from source table to staging tables using tmap.

Regards

suman.

[Jesperrekuh]

First of all, do some reading: Special characters

Find out which encoding/collation is used by your source.

If your source is Latin-1 and your target is Utf-8 , you end up in 'unrecognized' chars. 

However if you read the data from your target and save it as Utf-8 ... they are all recognized.

Encoding/collation is just a byte mapping to representation.

Look at your advanced setting where you can select encoding.