Conversion from datatype bigint to interger

[anandkumar442]

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.

[SURA]

You can handle it in SQL Server level or in DS Level.

But i would prefer to handle it in SQL level using CAST in the select statement.

DS User

[anandkumar442]

Hi ,

Thanks a lot for the quick response.
I was new to sql server and was trying with the datastage.
Now, I have handled in the query itself as suggested.

Thanks,
Anand.