Skip to main content

Controlling data warehouse tasks

Once the data warehouse tables have been created and the task has been generated, you can then proceed to run the data warehouse task. The data warehouse task extracts data from the landing tables, loads it into the staging tables, and finally loads the data into the data warehouse tables.

Information note

Ingesting a historical record deletes any history that is later than the ingested record. For example, if a data warehouse contains the following historical records:

2012 - Boston

2014 - Chicago

2015 - New Jersey

Ingesting the record 2013 - New York will delete the 2014 and 2015 records.

Data warehouse tasks can be run manually, scheduled to run periodically or run as part of a workflow. The section below describes how to run a data warehouse task manually. For information on scheduling data warehouse tasks or including them in a workflow, see Controlling and monitoring tasks and workflows .

Warning note

Data warehouse tasks cannot run in parallel with data mart tasks. Data warehouse tasks that update the same tables cannot run in parallel.

  1. Click the Manage button in the bottom right of the Data Warehouse panel. The Manage Data Warehouse Tasks window opens.

  2. If you have more than one task, in the left pane, select the task that you want to generate.
  3. Click the Run toolbar button. The window switches to Monitor view and a progress bar shows the current progress in terms of percentage.

    You can stop the task at any time by clicking the Abort toolbar button. This may be necessary if you need to urgently edit the task settings due to some unforeseen development. After editing the task settings, simply click the Run button again to restart the task.

    Information note

    Aborting a task may leave the data warehouse tables in an inconsistent state. Consistency will be restored the next time the task is run.

  4. When the progress reaches 100% completed, close the Manage Data Warehouse Tasks window.

Other monitoring information such as the task details (i.e. the number of rows inserted/updated) and the task log files can be accessed by clicking the Run Details and Log buttons respectively.

Once the data warehouse has been successfully loaded into the data warehouse tables, you can then proceed to the final part of the Compose workflow - defining and populating data marts. For more information, see Creating and managing data marts .

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!