Page 1 of 1
how to convert decimal to hexadecimal
Posted: Mon Sep 12, 2011 8:02 am
by reddyamarnath
Hi,
how to convert the decimal value to Hexadecimal values in job
Posted: Mon Sep 12, 2011 2:44 pm
by qt_ky
Posted: Mon Sep 12, 2011 2:57 pm
by arunkumarmm
There is a function Dtx() in server jobs but I'm not sure if that is available in Parallel. Maybe you can use a BASIC transformer and call this function.
Re: how to convert decimal to hexadecimal
Posted: Tue Sep 13, 2011 6:52 am
by baglasumit21
If you are inserting the data in oracle table then you can use the to_char function of oracle to convert the decimal value to hex. The same can be achieved by using a user defined query in oracle stage.
Rgds,
Sumit