Configuring the Data Mart Materializer task

A Data Mart Materializer task is responsible for the materialization of the Data Mart. Materializer Task creates a table and populates it with the content of the data mart. Multiple data mart materializer tasks might be configured to materialize data marts at varying frequencies to suit different operational needs.

Any data mart can be scheduled by associating it with a Data Mart Materializer task.

For details on the Task summary table, editing a task, and the run configuration, see Managing ETL and System tasks.

Enter the following details for the Run configuration of this task:

  • Name: Type a name for the task.
  • Deploy status: Select if the task is to be in the Test or Production environment.
  • Description: Type a description for the task.

Force materialization

The Data Mart Materializer task runs according to the configured schedule. If the ETL populates new data, it might take up to a next run of Data Mart materializer task to see the updated data in capacity views. You can add a custom property to force materialize the task and see the latest data in capacity views.

Do the following:

  1. Click the required Data Mart Materializer task name in the task summary table. The task details page is displayed.
  2. In the Run configuration table, click edit_simulation_icon.png edit this run configuration.
  3. Click the You can manually edit ETL properties from this page link at the bottom of the edit run configuration page.
  4. In the Add new property field at the bottom of the page, enter the new custom property as er.materializer.force, and click Add.
  5. Locate this new property in the list of properties, and then type a value as true.
  6. Click Save.
  7. On the System tasks page, locate the updated Data Mart Materializer task, and click Run the active run configuration.

The Data Mart Materialization task is run and latest data is updated in the views. 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*