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.
Conversion from datatype bigint to interger
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 29
- Joined: Tue Feb 16, 2010 8:47 am
Re: Conversion from datatype bigint to interger
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
But i would prefer to handle it in SQL level using CAST in the select statement.
DS User
-
- Participant
- Posts: 29
- Joined: Tue Feb 16, 2010 8:47 am
Re: Conversion from datatype bigint to interger
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.
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.