State File Demystified

[rameshrr3]

The State file is a binary data file that stores an uint32 or uint64 value depending on your operating system. in a 64 bit platform , it stores an uint64 value in each 8 byte block of data per node. To read current values of a surrogate key state file , you can use the unix command od -xc <state File name> or use a sequential file , whose schema has a single uint 64 column [BigInt unsigned , unbounded, Data format=binary, field width = 8] , with Format property record type as implicit , you can see the currently stored values using view data. Not sure if this will help anybody or can be of much use , but my attempt to demystify those mysterious state files and their 'garbage' data.

[jerome_rajan]

Great! :D Going to try it first thing when I reach office. Thanks for sharing.

[ray.wurlod]

It seems you have set up your state file with a block size of 1.