Generating the task statements
After the Storage Zone tables have been created, you then need to generate the task statements that will be used in the Storage Zone task. The task statements include the Mappings between the Landing Zone tables and the Storage Zone tables. If you need to make changes to the Mappings, continue from Managing task definitions.
- Changing a Primary Key in the source record will cause a new record to be inserted in the storage table.
- Regenerating the task statements after performing a non-supported change in the metadata will appear to succeed without errors or warnings, but the task will fail if run later.
-
Defining a single task that ingests data from several Landing Zones is not supported. As a workaround, you can create a separate task for each Landing Zone.
To generate the Storage Zone task statements:
-
Click the Data Storage Tasks button in the bottom left of the Storage Zone panel.
The Manage Data Storage Tasks window opens.
- If there are multiple tasks, in the left pane, select the desired task.
-
Click the Generate toolbar button, and select one of the following options:
- With validation - This is the default option for generating storage tasks.
- Without Validation - Select this option if you are sure that the storage tables are adjusted properly and the mapping is valid. The generation of storage tasks is much faster. Note that you could have errors later when running the task if something is not valid.
Information noteYou can also generate storage tasks with validation (default option) by clicking the Generate toolbar button.
The Generating Statements for Task: Name progress window opens. When the "Generate task finished successfully" message is displayed, close the window.
Information noteOnly mappings associated with the task in the Manage Tasks window will be generated.