I was trying to pass Salary field having datatype BigInt through aggregator. For the rows where Salary field has a number with length > 10 numeric characters , it was generating one magic number.
Design of job is as follows:
Code: Select all
Seq.File1 -----> Transformer -----> Aggregator --------> Seq.File2
The data in Seq.File1 was as follows.
Code: Select all
FName LName Salary
----------------------------------------
Aa Bb 768689900990000
Bb cC 990099000
Vv Xx 9900990000
Hh Ss 99009900001
Code: Select all
Name Salary
----------------------------------------
Aa,Bb 2147483647
Bb,cC 990099000
Vv,Xx 9900990000
Hh,Ss 2147483647
Has anyone faced this problem earlier? What is the solution to this problem?