Surrogate Key - File Block Size property

mchaves · Post by **mchaves** » Mon May 05, 2014 5:50 pm

Does anyone know if there's a parameter at project level to set the File Block Size? I want to reduce the gap between ids generated by the surrogate key generator.

ray.wurlod · Post by **ray.wurlod** » Mon May 05, 2014 6:17 pm

Pretty sure there's not. Nor does the Surrogate Key Generator stage give you the possibility of using a job parameter - the only choices are "system picked" and "user picked".

Enhancement request, perhaps?

rameshrr3 · Post by **rameshrr3** » Mon May 05, 2014 8:58 pm

Maybe force all surrogate key generators to use user picked , and have an environment variable to set this property - requires 'discipline' though