[CR #447948] Using components such as DB Staging, DB Data Sink Insert, DB Data Sink Update, or DB Data Sink Delete to access Sybase IQ can degrade performance.
Workaround: To improve performance, you can do one of:
Use the IQ Loader File via Load Table and IQ Loader DB via Insert Location loader components to speed up loading into Sybase IQ.
Use Adaptive Server Enterprise, Adaptive Server Anywhere, or Microsoft Access instead of Sybase IQ for the staging portion of your project.
If you still want to use Sybase IQ for staging, split the project into new staging and loading projects. Use DB Bulk Load Sybase IQ instead of DB Staging in the new staging project and use IQ Loader File via Load Table and IQ Loader DB via Insert Location to speed up loading into Sybase IQ in the new loading project.
