DB Staging is a Staging component that loads incoming data streams into a single staging area. DB Staging 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 are designed to 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 given size.
You can use Staging components to perform sorts or aggregations on formerly unordered records by using ORDER BY or GROUP BY clauses in the Query property. Data from heterogeneous sources can be joined by loading them into multiple tables of the staging database. You could also use this component for creating an intermediate image of the transformation for further inspection or processing.
Impact on simulation sequence
The DB Staging component impacts the flow of the simulation
by first retrieving all data from the original data sources, then
acting as a new data source for subsequent components. The component
allows overwriting of Read Block Size value of the original source
components.
