Page 1 of 1
Surrogate key - stat file
Posted: Wed Nov 16, 2011 4:37 am
by Suma Reddy
How to read stat file (FileName.sk) which is generated in surrogate key stage?
Posted: Wed Nov 16, 2011 5:37 am
by suse_dk
Use the Surrogate key generator to read the state file. Set the option "View state file" = yes
Posted: Wed Nov 16, 2011 3:10 pm
by ray.wurlod
Or use NextSurrogateKey() function if you actually want a surrogate key value.
Posted: Thu Nov 17, 2011 3:21 am
by Suma Reddy
Thanks Susanne.
Stat file contains below data
1 2
4 4
This content is based on block size.
How to find out Next surrogate key value from this stat file contents
Posted: Thu Nov 17, 2011 2:38 pm
by ray.wurlod
So, to clarify, you want to know the next (or, perhaps, current) value without actually incrementing the state file?
This will, of course, be different on different nodes.