The number of records forwarded to the next component within a single step is based on the value of Read Block Size.
One or more SQL statements to be executed during the initialization of the component. If you are using multiple statements, make sure you are separating them with a semicolon (;).
One or more SQL statements to be executed after all components have finished execution. If you are using multiple statements, make sure you are separating them with a semicolon (;).
See “Entering database connection parameters” for more information on the previous and the following properties:
Database
Schema
Standardize Data Format
Database Options
The DB Staging component impacts the flow of the simulation by first retrieving all data from the original data sources, then they act as a new data source for subsequent components. Both components allow overwriting of Read Block Size value of the original source components.
View Projects in DemoRepository and Help Flash movies Demo DB Staging and Demo DB Staging Double.
