In the destination table, without knowing i created the leave_balance data type as int. I have pushed all the data from table1 to table2, and after this, i dropped table1.
Now in table2, i have all the decimal values wiped off. For example, there were data of leave_balance like 10.5 in table1, which is showing as 10 now in table2. Can i do something on table2 which can show data as it was in table1?