Hi Everybody,
I am loading data to sequential flat file with sybase as my source using paralex. I am not getting the number columns in proper format. If the value is big, it gives me an exponential value. In the target i have specified as float (same as the source)
When i changed to numeric(9,2) it adds 0 if the number value is small (eg for 55000 , i am getting 0055000.00. I want the column value in the same way as in the source. Even changing the target type to Varchar gives me the same kind of output as the first one (exponential)
If the source value is 9500000 then the target value should be the same.
How to handle the same in Paralel extender. Let me know.
I am new to Paralex.
cheers,
Gopal
Not getting data in the proper format in the target
Moderators: chulett, rschirm, roy