Datatype issue:

kumar444 · Post by **kumar444** » Wed Feb 02, 2011 2:52 pm

Any help to fix this thing is appreciated.

Oracle---> join--->sort---->union----->Sequential file.

columnname(Number(15,0)) target(Integer(15.0))

25558 -2345635343
36667 -34567
12345 -45636

I have set the datatype as integer 15,0 in every stage in the flow and i am receiving the above negative values in target. This source column is not transformed through out the flow. It should return the values unchanged.

-----------
Kumar.

kbsuryadev · Post by **kbsuryadev** » Wed Feb 02, 2011 3:02 pm

What is your input data type

ray.wurlod · Post by **ray.wurlod** » Wed Feb 02, 2011 3:22 pm

What is "union" in your job design?

kumar444 · Post by **kumar444** » Wed Feb 02, 2011 3:36 pm

Input datatype is number(15,0) from Oracle. I have set this as integer 15,0 in every stage . I receive negative numbers in the output. I have two similar dataflows coming into the UNION( but i have written only a single flow upthere in the topic).

kumar444 · Post by **kumar444** » Wed Feb 02, 2011 3:50 pm

Ray, I mean to say a FUNNEL (union)

kbsuryadev · Post by **kbsuryadev** » Wed Feb 02, 2011 4:35 pm

try using bigint

ray.wurlod · Post by **ray.wurlod** » Wed Feb 02, 2011 7:11 pm

There's no such thing as Integer(15) - the largest possible signed int32 only has 10 digits. Hence the recommendation to try BigInt.

What happens in binary when you try to store too large an integer is that you get "arithmetic overflow". The most significant bit tends to be set, which signals a negative integer. The answer will almost certainly be wrong anyway. You need to prevent this from occurring by using a data type that is able to handle sufficiently large numbers.

nayanpatra · Post by **nayanpatra** » Wed Feb 02, 2011 10:16 pm

You may also try with DECIMAL(15,0) and not INTEGER(15,0)