Popular White Paper On This Topic

I'm not quite sure where you got the "translation" for your hex value but "COMPETITOR" in all caps in hex would be "434F4D50455449544F52". And I'm not aware of any way to do that kind of conversion out of the box, so it seems to me you'd either need to do something in Informatica leveraging Java or find a way to convert that in either the source or target databases.

In Oracle you may be able to use the HEXTORAW function, never tried it myself however.

In advance set the properties of the flat file as UTF8-encoding of Unicode
and then change the source connection string as per the Unicode. While
checking the data in the target table or flat file, you need to set the
setting for unicode as UTF-8 in Tera data database or in Unix(Putty).

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.