How to keep the data warehouse synchronised with the source systems?
Change tracking offers the functionality you're looking for. When switched on, SQL Server creates additional internal tables.  Changes to your data tables are noted in these internal tables.  System functions allow you to pull changes out of these internal tables and transfer only changed rows.

A related technology - Change Data Capture - allows you to see the "before" and "after" values of changes.