title: Fetching data from data warehouse in correct way
body: <p>I am running job weekly to extract data from DW . The problem i am facing is the data in DW is updated every day by deleting and reloading the data for last 14 days from the source . My weekly  job is scheduled to  fetch last week's data  every monday. But because of this updation on DW side , we are missing lot of data . </p>
  
  <p>One solution here could be to run our weekly job to fetch data for (current date- 21 days ) to (current date -14 ) , which will be outside of the window of updation in DW . However in this scenario , we would always have 14 days old data . </p>
  
  <p>Is there any better way to acknowledge this problem so that i don't end up having 14 days old data .</p>