User`s guide

CHAPTER 4 Projects and Jobs
User’s Guide 41
Stage properties — Enter the general part for the Load Stage properties of
the DB Bulk Load IQ component into the Stage and Stage Server
properties, that is the paths to the staging files ended by the path delimiter
(for example C:\ETLStage\) or pipe:// for a named pipe. Refer to “DB
Bulk Load Sybase IQ component” on page 119 for a detailed description
of these properties.
5 Enter transfer settings.
Additional properties for each table to be transferred are provided.
a Select source attributes.
By default all attributes of a table are selected for transfer. To change
the attribute selection, click Columns.
Deactivate the Transfer check box for every attribute to exclude from
transfer, or select multiple attributes and choose Exclude from the
pop-up menu.
b Select destination tables.
It is assumed that source and destination table names should be equal.
To use different names, you must provide these for each source table
by either entering a new name into the Destination field or selecting
an existing table from the drop-down list.
c Use the Prefix and Extension properties to qualify the file or pipe
names. It is not recommended to change the generated names in the
Stage and Stage Server columns of the Transfer List.
There are some additional options that can be switched on or off. To
change the value of an option you can either click a single check box
or select all lines you want to change and choose Activate or
Deactivate from the pop-up menu:
• Data model options — Before the transfer can start, you must
verify that the destination tables exist. These options can help
you set up the destination data model. They do not affect
execution but they do affect the data model when it is created
from the template.
To create a non-existing destination table based on the selected
source attributes, select the Create Table option. If you want a
table to be re-created even if it exists, select Drop Table.
• Execution options — These options affect the execution on
project level.