We are extracting data from db2 and using modify stage converting into string then finally loading into sequential file.
Job Design:
Db2 stage -->Modify stage -->sequential file stage
Source column name : Cust_amount
Datatype : Decimal (20,2)
Target column name : Cust_amount
Datatype : Varchar(25)
Modify stage specification:
Code: Select all
Cust_amount:string[max=25] = string_from_decimal [suppress_zero](Cust_amount)
Sum of the column @ database level
1223454545903.30
Sum of the column @ file level (After loading into sequential file)
1223454545901.50
we observed loss of data at sum of the column not at the row level. we have get this value after loading into sequential file (1223454545903.30) but we are getting different values.
Tried the following other options
1. db2 stage --> seq file stage (we are seeing some difference)
Any greatly appricated.
Thanks
Suresh