检测数据Feed的已更改行的最佳做法是什么？

I am researching best practices for managing a weekly data feed to a 3rd party OLAP service. The analysis database will be initialized with a full data dump. Subsequent weekly feeds will provide new and updated rows. The data is sourced from a SQL Server 2005 database.I am researching best practices for managing a