User`s guide

Using templates to create projects and jobs
42 Sybase IQ ETL 4.1
Select Truncate to remove all records from the destination table
before loading. This option corresponds to the
Truncate Table
property of the target component.
The failure of a Critical project will cause the job to stop
execution and signal failure. This and the Ignore Errors options
correspond to the properties of the Multi-Project job component.
The Ignore Errors setting does not affect the projects generated
through this template.
6 Process migration template data.
The last screen in the wizard allows you to perform all desired tasks on the
collected data.
Except for Save, you can perform all tasks from the template pop-up menu
in the Navigator section:
• Storing the Template — If you select Save Template, the template is
stored in the repository. For a stored template, all other tasks can also
be performed from the popup menu in the Navigator section. Storing
allows you to reuse the collected data for similar jobs.
• Generating Transformation Objects — Select Build Transformations
to create one project for each source table and a migration job that
controls the execution of all these projects.
• Creating the Destination Data Model — To set up the destination data
model according to the data model options you entered, select the
Create Data Model.
• Executing the job — The Execute Job option is available only if Build
Transformations is activated. If you selected this option after the
migration template data has been processed, the generated job will be
executed.
7 Perform selected tasks.