Archives of the TeradataForum
Message Posted: Thu, 20 Dec 2007 @ 21:43:05 GMT
Our warehouse is generally in 3nf. We are looking at our first production star model and the designer is trying to find a way to tell is the new row coming in is a change to a current row. She has considered concatenating all the attributes and comparing them, but that seem "expensive".
Is there a way of creating a checksum attribute to identify changes? I have looked at some checksum info in the manuals, but that doesn't seem to be what I am looking for. Locking for checksum seems close, but the data won't be coming in from a cursor, it will be a select insert from a table.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|