I noticed that when data is loaded to my warehouse it is done with a temp table and a merge statement.  When only a small number of rows are updated would it be possible to perform a direct insert, or update to the destination table?  

This can help warehouses be more performant when small numbers of rows are being synced per table.