(Jag Singh) In the ideal world the operational source would provide a mechanism for identifying changes made to the data since the last extract, also known as change data capture (CDC). The source may contain update date, database online log scrubbing mechanism, or audit logs, etc. for the purpose.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help