Specifications

Modifying the data pipeline definition
130 InfoMaker
Choosing a pipeline operation
When InfoMaker pipes data, what happens in the destination database depends
on which pipeline operation you choose in the Options drop-down list at the
top of the workspace.
Table 4-3: Effect of pipeline operations on the destination database
Dependency of modifications on pipeline operation
The modifications you can make in the workspace depend on the pipeline
operation you have chosen.
When using
Create or Replace
When you select the Create - Add Table option (the default) or the Replace -
Drop/Add Table option, you can:
• Change the destination table definition.
Follow the rules of the destination DBMS.
Pipeline operation Effect on destination database
Create - Add Table A new table is created and rows selected from the
source tables are inserted.
If a table with the specified name already exists in
the destination database, a message displays and
you must select another option or change the table
name.
Replace - Drop/Add Table An existing table with the specified table name is
dropped, a new table is created, and rows selected
from the source tables are inserted.
If no table exists with the specified name, a table is
created.
Refresh - Delete/Insert Rows All rows of data in an existing table are deleted,
and rows selected from the source tables are
inserted.
Append - Insert Rows All rows of data in an existing table are preserved,
and new rows selected from the source tables are
inserted.
Update - Update/Insert Rows Rows in an existing table that match the key
criteria values in the rows selected from the source
tables are updated, and rows that do not match the
key criteria values are inserted.