Drag the DB Staging component onto the Design window.
Connect the DB Staging IN-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 to create the connection. See “DB Staging properties list” for specific field requirements.
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 Truncate Table and the 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.
Updating port structure with database changes