Configuring the Data Mart Materializer task

A Data Mart Materializer task is responsible for the materialization of the SQL Data Mart. Depending on the TrueSight Capacity Optimization deployment, there can several tasks belonging to this category, that materialize SQL data marts at different frequencies.

Any SQL Data Mart can be scheduled by associating it to a Data Mart Materializer task. Ensure that the data marts are scheduled after the import time of the source data. For example, data marts that need data from Gateway VIS file ETL should be run after the daily import of this ETL is complete. 

The following details must be entered for the Run configuration of the task:

Field	Description
General configuration
Name	Type a name for the task.
Environment	Select if the task should be in the Test or Production environment.
Description	Type a description for the task.
Scheduling options
Hour mask	Select the time of the day when the task is scheduled to run.
Day of week mask	Select the days of the week to schedule the task.
Day of month mask	Select the days of the month to schedule the task.
Apply mask validation	Select if you want to mask the validation or not.
Execute after time	Specify the time period after which the scheduler task must be executed.
Enqueueable	Select if you want the task to be enqueued if other tasks are being executed.