AsInteger conversion data issue
Posted: Sat Feb 02, 2013 12:55 am
Hi,
I have source column float datatype mapped to Integer in target. I used AsInteger function in transformer to convert Float to Integer , as without conversion job was failing as I was mapping float to Integer.
After explicitly converting Float to Integer in target table field value is coming with negative sign e.g. source value :123 target value -123.
When I searched in forum, I got a post saying it is due to data over flow.
I checked table data( length of the column) It has maximum length 10 and I am running the process with very few records, so I made sure record length <=10.
Can anyone please let me know the reason.
Thank you in advance.
I have source column float datatype mapped to Integer in target. I used AsInteger function in transformer to convert Float to Integer , as without conversion job was failing as I was mapping float to Integer.
After explicitly converting Float to Integer in target table field value is coming with negative sign e.g. source value :123 target value -123.
When I searched in forum, I got a post saying it is due to data over flow.
I checked table data( length of the column) It has maximum length 10 and I am running the process with very few records, so I made sure record length <=10.
Can anyone please let me know the reason.
Thank you in advance.