Setting the Incremental Load of the Data Warehouse

Using the incremental load of the data warehouse, you can enable the Source Objects tables to update and insert modified and new rows from the composers. The incremental load uses the checksum to detect changes on each row of a source object.

To set the incremental load of the data warehouse:

  1. On the Source tab, expand the tree view to locate the object.
  2. Right-click the source object and select Detailed Properties > Columns.
  3. In Columns, select a column name.
  4. In Changed date, verify the description.
  5. For table properties, select:
    • Calculation properties – Modified Date
    • Activated check box
  6. Click OK.
  7. Go to Processing options > Extractions options.
  8. In Define how data should be extracted, select an extraction option. (The default selection is Full extraction.)
    1. For Extract Modified rows since last extraction
      1. Select the Modified since text box.
      2. Select the month, year, and day for the last extraction date on the calendar.
    2. For the Extract date interval
      1. Select the first text box and select the month, year, and day from the first interval extraction date on the calendar.
      2. Select the second text box and select the month, year, and day from the second interval extraction date on the calendar.
    3. For the Extract Last days changes, select the number of days from the current date to the last day that the table modification occurred.
  9. Click Refresh SQL.
  10. Verify in the SQL Statement preview if the query has been applied.
  11. Click Apply then OK.
  12. Compile the source object and run ETL.
  13. Verify the table using browse data.