Conversion from datatype bigint to interger
Posted: Tue Sep 20, 2011 11:32 pm
Hi,
I am getting a waring while extrating the data from source to target.
The data type in the source table is bigint identity and I need to load it into the targer as integer 10.
when I ran the job, am getting the below warning.
When checking operator: When binding output interface field "UNIQ_KEY" to field "UNIQ_KEY": Implicit conversion from source type "decimal[19,0]" to result type "int64": Possible range limitation.
Is there any way, I could avoid this warning.
Thanks,
Anand.
I am getting a waring while extrating the data from source to target.
The data type in the source table is bigint identity and I need to load it into the targer as integer 10.
when I ran the job, am getting the below warning.
When checking operator: When binding output interface field "UNIQ_KEY" to field "UNIQ_KEY": Implicit conversion from source type "decimal[19,0]" to result type "int64": Possible range limitation.
Is there any way, I could avoid this warning.
Thanks,
Anand.