I have a server job that checks for type 2 scd, if any of the fields have changed via crc32(all fields concatenated) I either update(expire) an existing record and write a new version of the expired record or it is a new record and is an insert only. Problem that I have is that sometimes the update existing/expire process does not complete before the job tries to insert the new dimension record and the insert fails because of a unique constraint on the natural key and the expire date. Any suggestions, short of splitting the server into 2?
Thanks
Marc
Type 2 question
Moderators: chulett, rschirm, roy
Re: Type 2 question
If you land your data to a file e.g. you can never have this.
Ogmios
Ogmios