I am trying to use Surrogate Key generator stage using Flat file in Datastage 8.1. When i am generating for 10 records, first time values are coming as 1 to 10. Next time it is genrating as 1001 to 1010...next 2001 to 2010 next 3001 to 3010 .....
I am running the job in 4 node configuration.
How can i achive the sequential values? like 1 to 10 ... 11 to 20 next 21 to 30 .
I don't have any docs access right now... what other options are there for File Block Size besides 'system picked'? And there's nothing like a "cache" option?
-craig
"You can never have too many knives" -- Logan Nine Fingers
To control the block size for key ranges, add the File Block Size property to the Options group, set this property to User specified, and specify a value for the block size