Hello Experts,
I am getting extra spaces in one field (diag_code_type) at table diagnosis_d.
Table is like below.
In source actual length of value is 17, however length of column become 30 in target diagnosis_d.
I tried to trim the column in source before populating the value to target table, however it did not work.
I guess space is getting added once value is populated.
What would be best approach to fix this?
Thanks,