If I am defining the legth of column is 10(Integer Type) but my real data length is only 5. I need to use all length which is specified in the column metadata.
My real data is : 12345 but I need a format like this. i.e 0000012345
The leading zeroes won't exist in an integer column, only when you display or move the column to a character one. If you create a CHAR(10) column and a derivation of "RIGHT('0000000000':In.IntegerColumn,10)" you should get your required output.