DSXchange

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 .

What settings have you specified in the stage?

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

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?

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