data issue

[scorpion]

hi,

I have sybase views are as my source database and i am loading in the file in my jobs.

The value for one of the column in sybase view is coming up like exponentials.

i.e. "1.0000000000010001e-006"

but i need this value to be populated as "0.00",instead of exponentials.

can any one direct me in this?

thanks in advance.

[Maveric]

Looks like your source is floating point decimal data type and target will be decimal. Float to decimal need not be converted explicitly. So a direct mapping should work.