Drag the DB Staging
component onto the Design window.
Connect the DB Staging input port to the component
that provides the inbound data.
To add input streams to the DB Staging component, you can
drop connections from the data providing component on the staging component.
The ports are automatically created by the component.
In the Properties window, add the Connection Parameters
to the database where you want to add staging tables.
Specify a valid interface and host name.
Note:
If the staging tables you are going to use already exist,
skip the next step.
In the Design window, right-click the DB Staging
component and select one of:
Create Staging
Table from Input – select the appropriate port structure,
and click OK. Enter a name for the new table.
Create Staging Table from Port – enter
a name for the new table and select an appropriate port structure.
Click Apply.
In the Add table window, verify that the new table
information is correct and click Create.
In the Properties window, click the Stage Options
icon.
The Stage Options window lets you define the Truncate Table and
Write Block Size options for each staging table.
In the Properties window, click the Query icon and
create a query to select data from the staging area.