Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
richardps
Starting Member
33 Posts |
 Posted - 2007-05-01 : 04:27:39
|
| Hi,I would be grateful to hear people's views on how to avoid / protect against data entry duplication. If for example you load batches of data on a regular basis (for example daily). How would you protect against loading the same day's data twice?Would you incorporate a field or some form of code perhaps?Having not been on any datawarehousing courses I would be grateful for all comments and references to common / standard practices.I look forward to hearing your responses.Regards,Richard. |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-05-01 : 09:27:23
|
| I tend to store a hash (checksum) of the incoming file and compare this to previous files.Mark |
 |
|
|
|
|
|
Data Duplication (avoidance)