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. |