This content has been marked as final. Show 3 replies
If your target is Oracle DB then do
and execute the mapping on staging area
What is your target technology ?
There are ways to do it. One of the way is to create function
You can create ODI function to convert Hexadecimal to Integer.
For example if you are using Oracle as your staging or target technology .. you can use
Oracle you can use
SYS_OP_RAWTONUM('AA') or to_number('AA', 'xx').
Other can be directly using features of target or staging technologies to get the desired output.
Thank you both for you replies.
The target is an XML file. I changed the staging area and I found the functions you both mentioned.
I won't go into details but unfortunately this data isn't readable because finally it's not really hexadecimal. My problem lies elsewhere.
However, I think your answers will be helpfull to others.