My file has the below data
but when i load using informatica it comes as below , please help on what are the changes need to be done before loading ?
Where u are loading database(which one) or File?
If your source is a flat file then you need to edit the variable for code page in the .profile file in the unix server to get this issue resolved.
try below options,
option1-Make sure code page is same in all places(src,tgt connection,in DB,in server..etc)
UPDATE TABLE SET FIELD =
CONVERT (FIELD,'utf8', 'WE8MSWIN1252' )
Note :- This query will encode all the western European characters only to UTF-8.