title: Tracking of attribute change
body: <p>I'm not DBA and cannot implement triggers, nor use CDC!</p>
  <p>In staging area I do have a PRODUCTS table with the following columns: <code>PROD_ID, ATTR1_ID, ATTR2_ID, CREATED_BY, UPDATED_BY</code>. When app user changes product's attribute #1 the <code>ATTR1_ID</code> is changed and user's ID is saved in <code>UPDATED_BY</code> column. I need information who and when changed the attribute #1. Application does not track changes so I need to do it on my own in background. I created one history table for tracking ATTR1 changes with columns <code>PROD_ID, ATTR1_ID, UPDATED_BY, DATE_FROM, DATE_TO</code></p>
  <p>Data in this table should look like:</p>
  <pre><code>PROD_ID  ATTR1_ID   DATE_FROM     DATE_TO
        1       100  20.02.2021      &lt;null&gt;
        2       200  21.02.2021  22.02.2021   &lt;-- attribute changed on 22.02.2021 from 200 to 201
        2       201  22.02.2021      &lt;null&gt;
        3       100  23.02.2021      &lt;null&gt;   &lt;-- new product started
  </code></pre>
  <p>I intend to create PRODUCTS_OLD table for previous day data and PRODUCTS_NEW for current day data. Then I intend to copy PRODUCTS data into PRODUCTS_NEW table every day. Using MINUS operator I can see changes between new and old (yesterday) table. After detecting changes and inserting/updating information about that in separate history table I copy new data into old table and repeat this every day.</p>
  <p>What is the best way to do all this?</p>