title: How to perform Archiving and purging in Azure SQL database
body: <p>I'm using Azure SQL database as my source database.Which include 10 tables.
  I need to do archiving and purging in the table in a period gap of one year.Currently I am using Azure data factory to move data from source database to data warehouse.Can I do archiving and purging using data factory.If not please suggest me a right way to perform this Activity.</p>