Specifications

CHAPTER 4 Working with Data Pipelines
Users Guide 129
Table 4-2 lists properties that you can modify that apply to the destination
table’s columns and keys. These properties display under the properties that
apply to the table itself and most can be modified only for the Create and
Replace pipeline operations.
Column names and datatypes that cannot be modified
You cannot modify the source column names and datatypes that display at the
left of the workspace.
Table 4-2: Pipeline properties for the destination table’s columns and
keys
Item Description Default How to edit
Destination
Name
Column name Source column name. Enter a name.
Type Column datatype If the DBMS is unchanged,
source column datatype. If the
DBMS is different, a
best-guess datatype.
Select a type from the
drop-down list.
Key Whether the column is a key
column (check means yes)
Source table’s key columns (if
the source is only one table and
all key columns were selected).
Select or clear check boxes.
Width Column width Source column width. Enter a number.
Dec Decimal places for the column Source column decimal places. Enter a number.
Nulls Whether
NULL is allowed for
the column (check means yes)
Source column value. Select or clear check boxes.
Initial Value Column initial value Source column initial value. (If
no initial value, character
columns default to spaces and
numeric columns default to 0.)
Select an initial value from the
drop-down list.
Default
Val ue
Column default value None. Default values stored in
the source database are not
piped to the destination
database.
Select a default value from the
drop-down list or enter a
default value. Keyword values
depend on destination DBMS.