Hi All,
I have been lurking for a while on this site and the dev net for Ascential. I am looking for a little feedback on a datastage process. Basically, I am implementing a type 2 scd using michael's example,(thanks Mike). My question is that, right now I end putting CRC values and a natural key out to a hash file, would it be wise to store this in the db also as a way of backup? BTW, Thanks to Michael and Ken for their help in PM's.
Thanks
Marc
New to DS
Moderators: chulett, rschirm, roy
Marc,
Actually storing the CRC value in the DB is a good idea and one I try to get each of my customers to do. This will prevent you from having to generate a CRC value for an existing record. It's one less step you have to perform. When you are updating or inserting new DW rows you already have this information so why not store this value in the DB?
Regards,
Michael Hester
Actually storing the CRC value in the DB is a good idea and one I try to get each of my customers to do. This will prevent you from having to generate a CRC value for an existing record. It's one less step you have to perform. When you are updating or inserting new DW rows you already have this information so why not store this value in the DB?
Regards,
Michael Hester
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
-
- Premium Member
- Posts: 67
- Joined: Wed Apr 14, 2004 11:33 am
Michael,mhester wrote:Marc,
Actually storing the CRC value in the DB is a good idea and one I try to get each of my customers to do. This will prevent you from having to generate a CRC value for an existing record. It's one less step you have to perform. When you are updating or inserting new DW rows you already have this information so why not store this value in the DB?
Regards,
Michael Hester
True enough and easy enough to do. BTW, I PM'd you a question with you CRC32 example. Thanks