DB Staging

DB Staging loads incoming data streams into a single staging area. It buffers all incoming data, then creates an outgoing data stream, which represents the result set of a given select statement.

You can create staging tables based on the output port structure of the preceding component. Although many transformation components work on a record-by-record basis, the staging component works in two phases:

Phase 1 – collect all records from the preceding components.
Phase 2 – run the query and provide the records of the result set in blocks of a given size.

You can use staging components to perform sorts or aggregations by using ORDER BY or GROUP BY clauses in the Query property. You can join data from heterogeneous sources by loading them into multiple tables of the staging database. You can also use the DB Staging component to create an intermediate image of the transformation for further inspection or processing.

Note:

In simulation, the DB Staging component first retrieves all data from the original datasources, then acts as a new datasource for subsequent components. The component allows the Read Block Size value of the original source components to be overwritten.

Configuring a DB Staging Component
Add and configure a DB Staging component.
DB Staging Properties List
The DB Staging Properties list identifies the required and optional properties of the Data Staging component.
Running DB Staging Demos
Sybase IQ InfoPrimer includes a demonstration for the DB Staging component. These demos are available as Flash demos and as sample projects in the demo repository.

Parent topic: Staging Components