The problem is due the data type of the column . Go to the physical layer and check the data type . It would be of 'Double' data type .. Change it to 'Int' data type. This would solve the problem . Posting it for the benefit of others who face similar issues. let me know if it helps anyone..