User`s guide

Overview
70 Sybase IQ ETL 4.1
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.
Setting required properties
Before a component is ready to be used within a project, you must set required
property items. When you add a component to the Design area, the window
requesting the setting of the required parameters is automatically opened.
Ports and links
A component has IN-ports to receive data and OUT-ports to pass the data after
it has processed it. When stepping a component, the data forwarded through the
OUT-port is delivered to the IN-port of the subsequent component.
Ports pass data through connecting links. Every link has the capability to map
the fields of the ports it connects to. Ports also indicate the status of a
component (green for “ready-to-use”, red for “missing or invalid mandatory
property settings”).
Data blocks and visualization
The data stream that is passed from component to component during a step-by-
step simulation is adaptable and highly transparent. The number of records that
are being processed within a step can be configured. You can preview data at
any stage by previewing the content of a Link or by looking into the component
itself.
Repetitive stepping
During a simulation the component can be executed (stepped) separately from
its adjacent component. Repetitive steps will not increase the number of
records delivered to the downstream component.