User`s guide

Staging components
108 Sybase IQ ETL 4.1
5 Right-click the component and select either Create Staging Table from
Input or Create Staging Table from Port. The commands let you create the
staging tables optionally based on the IN-port structure of the component
or the structure of any other port within the project. However, you can also
create the staging tables manually by using third party tools.
Staging options are defined by using the Stage Options window. This
window also lets you define the Truncate Table and the Write Block Size
for each staging table.
6 Open the Query window by clicking Query button, and enter the query that
selects the data from the staging area.
Optional properties
Read Block Size
The number of records forwarded to the next component within a single step is
based on the value of Read Block Size.
Pre-processing SQL
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 (;).
Post-processing SQL
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” on page 71 for more
information on the previous and the following properties:
• Database
• Schema
• Standardize Data Format
• Database Options