title: Reading incremental data based on the value of composite Primary key
body: <p>I have an OLTP (source) from where data has to be moved to the DWH(destination) on an incremental basis. 
  The source table has a composite Primary Key on Loan_id, AssetID as shown below.  </p>
  
  <pre><code>LOAN_ID, ASSETID, REC_STATUS
  '12848','13170', 'F'
  </code></pre>
  
  <p>Had it been a single col primary key then I would check for the max value of the column at the destination and then read all the records from the source where the Primary key value is greater than the max value at the destination, but as it is a composite primary key, this will not work. </p>
  
  <p>Any idea how this can be done using T-SQL Query?</p>
  
  <p>Specs: Source is an MYSQL DB and the destination is MSSQL 2012. The connection is made using a linked server. </p>