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 has to start with one or more Source components. Source components have no IN-ports and one or more OUT-ports.
Transformation components, Lookup components, and Staging components – apply specific transformations to the data in the transformation stream. These types of components have at least one IN-port and one OUT-port.
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.
While different from a functional point of view, all
components share common concepts.
