Specifications

Modifying the data pipeline definition
128 InfoMaker
Table 4-1 lists properties you can modify that apply to the destination table.
These properties display at the top of the Data Pipeline painter workspace.
Table 4-1: Pipeline properties for the destination table
Item Description Default How to edit
Table Name of the destination table. If source and destination are
different, name of first table
specified in the source data
or name of the stored
procedure. If the same,
_copy is appended.
For Create or Replace, enter
a name.
For Refresh, Append, or
Update, select a name from
the drop-down list.
Options Pipeline operation: Create, Replace,
Refresh, Append, or Update.
Create - Add Table. Select an option from the
drop-down list. See
Table 4-3 on page 130.
Commit Number of rows piped to the
destination database before InfoMaker
commits the rows to the database.
100 rows. Select a number,
All, or
None from the drop-down
list.
Key Key name for the table in the
destination database.
If the source is only one
table, the table name is
followed by _x.
(Create or Replace only)
Enter a name.
Max Errors Number of errors allowed before the
pipeline stops.
100 errors. Select a number or
No Limit
from the drop-down list.
Extended
Attributes
(Create and Replace only) Specifies
whether or not the extended attributes
of the selected source columns are
piped to the extended attribute system
tables of the destination database.
Not checked. Click the check box.