Managing task definitions

Task definitions contain the mappings between the columns in the Landing Zone tables and the columns in the Storage Zone tables (and any transformations applied to those mappings). The same mappings can be used by several tasks. You can create new tasks, duplicate tasks and edit existing tasks as required.

The following options are available:

• Adding and duplicating tasks
• Column mappings
Information note
• For each Compose task, all of the mapping tables should be populated by data from one Replicate task.
• You must regenerate the task statements and then run a Storage Zone task whenever the mappings are modified. Populating the Storage Zone can either be done manually as described in Controlling data storage tasks or automatically as described in Scheduling tasks.
  If you have already run the data mart tasks, then you also need to regenerate the data mart ETLs and run the tasks again as described in Managing task definitions.
• Using lookup tables
• Dropping and recreating tables