title: Data loading in Azure DataWarehouse _Solution required
body: <p>I would like to storing the data in the DWH in a consistent matter. Every week I need to load data in AzureDW from on-Prem SQLDB.
  The thing is that I have primary key in a table which I get every week. The example of table</p>
  <p><a href="https://i.stack.imgur.com/WRfmn.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WRfmn.jpg" alt="enter image description here" /></a></p>
  <p>I want to design in such a way that all 4 records gets stored in DW.</p>
  <p>Shall I use surrogate key or is there some other better way?</p>