State File Demystified
Moderators: chulett, rschirm, roy
State File Demystified
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.
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Great! :D Going to try it first thing when I reach office. Thanks for sharing.
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: