Sybase ETL components are used to create projects and jobs. These components are available in the Component Store. Project components include:
Source components – deliver data for a transformation stream. A project typically starts with one or more source components. Source components have no IN-ports and at least one OUT-port.
Transformation components, Lookup components, and Staging components – apply specific transformations to the data in the transformation stream. These types of components have both IN-ports and OUT-ports.
Destination components (also called data sinks) – write data to specific targets. destination component have one IN-port and no OUT-ports.
Loader components – extract and load data from a source database or file into the IQ database, without performing any transformation.
