Surrogate key generator stage in datastage 8.1

prashanth.spl · Post by **prashanth.spl** » Fri Oct 01, 2010 5:18 am

Hi,

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 .

chulett · Post by **chulett** » Fri Oct 01, 2010 5:35 am

What settings have you specified in the stage?

prashanth.spl · Post by **prashanth.spl** » Fri Oct 01, 2010 6:03 am

Hi,

I have used the following options:

File Block size: System Picked

Generate Key from Last Value: No ( I tried Yes Also ..No difference)

Execution mode: Sequential

chulett · Post by **chulett** » Fri Oct 01, 2010 6:12 am

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?

nitkuar · Post by **nitkuar** » Fri Oct 01, 2010 6:32 am

extract from designer guide:

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