User`s guide

User’s Guide 69
CHAPTER 6
Components
Overview
The Sybase IQ ETL components are used to create projects and jobs. (See
Chapter 4, “Projects and Jobs.”) They are located in the Component Store.
Project components are divided into the following:
• Source components
• Transformation components
• Lookup components
• Staging components
• Processing components
• Destination components
• Job components
Source components deliver data for a transformation stream. A project has
to start with one or multiple Source components. This component type has
no IN-port and one or more OUT-ports.
Topic Page
Overview 69
Source components 81
Transformation components 93
Using Lookup components 101
Staging components 107
Processing components 109
Destination components 110
Job components 121