Page 1 of 1

Issue with Surrogate Key generator stage in 8.1 PX version

Posted: Wed Feb 16, 2011 9:38 am
by krishna.m
Hi All,

I have a problem in using surrogate key generator stage. I am using the "Source Type=Flat File". In the options i am selection the below.

File Block Size= User Specified
User Specified Block Size=1
File Initial Value=1080019000000000000

I am ending up with the below fatal error.

"When processing argument -start_valueWhen processing number: 1080019000000000000 is less than lower limit 1"

From the DS help i have learnt that the max value that can be generated is INT 64 i.e 9,223,372,036,854,775,807. The value that i am providing is way lesser than the max value. Please help me out in resolving this issue.

Re: Issue with Surrogate Key generator stage in 8.1 PX versi

Posted: Tue Mar 15, 2011 5:55 pm
by LS
Hi krishna.m.

Are you running a 64bit machine? Also check your compiler options...

Have fun,
me.

[snip]

Posted: Tue Mar 15, 2011 6:42 pm
by ray.wurlod
With the value 1080019000000000000 you have achieved a arithmetic underflow. Research the term "twos complement" to see why.