With Sybase IQ as the staging platform, Sybase ETL 4.9 lets you bulk-load data into staging tables using the Load Table statement, thus, leading to faster performance. In earlier versions, the DB Staging component could use the INSERT statement to perform only row-based operations for loading the incoming data into the target database.
The DB Staging component has been enhanced to:
Create tables automatically based on the input port structures at runtime. You can remove a table created at runtime once the project finishes processing.
Execute additional SQL scripts to modify or update the staging tables before output is created. You can now execute SQL transformation scripts once all the data from the transformation flow has been loaded into the tables associated with the input ports, and before retrieving the query result set.
Ensure data is committed at the end of the write operation for a successful execution, and rolled back for an unsuccessful execution.
You need not specify the Load Stage Path when client-side loading is enabled for your Sybase IQ 15.0 staging database with ODBC as the interface. The IQ server automatically uses its default LOAD TABLE statement to add records from files located on the remote host machines into the Sybase IQ table.
See Chapter 5, “Components” in the Sybase ETL 4.9 Users Guide.
