 |
 |
Archives of the TeradataForum
Message Posted: Thu, 20 Dec 2007 @ 21:43:05 GMT
| Subj: | | Row CheckSum |
| |
| From: | | Hassinger, Bill |
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.
Thanks
Bill H
| |
