Data mismatch issue with DB2
Posted: Wed Sep 24, 2008 5:52 am
I have simple Job
Seq----> Transformer---->Db2
I have following records in source:-
31,1,1,N,206,2181365126
33,1,1,N,208,2181364446
35,1,1,N,212,2181365113
37,1,1,N,214,2181365076
38,1,1,N,215,2181364745
Sixth col is Integer data type and the file is imported successfully.
But when records are transfered to DB2 table,input records do not matches with source data(6th col records).
I am doing simple transformation in transformer stage.
I dont know what is problem exactly.
Please help me to resolve this issue
Thanks in advance
Seq----> Transformer---->Db2
I have following records in source:-
31,1,1,N,206,2181365126
33,1,1,N,208,2181364446
35,1,1,N,212,2181365113
37,1,1,N,214,2181365076
38,1,1,N,215,2181364745
Sixth col is Integer data type and the file is imported successfully.
But when records are transfered to DB2 table,input records do not matches with source data(6th col records).
I am doing simple transformation in transformer stage.
I dont know what is problem exactly.
Please help me to resolve this issue
Thanks in advance