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.
Transformation components, Lookup components, and Staging components have at least one IN-port and one OUT-port and apply specific transformations to the data in the transformation stream.
Destination components (also called data sinks) write data to specific targets. This component type has one IN-port and no OUT-port.
While different from a functional point of view, all components share common concepts.
