User`s guide

CHAPTER 1 Sybase IQ ETL
User’s Guide 3
Component variables and ports
All data within a project flow through component ports called IN-ports and
OUT-ports. Each port owns the structure of the data flow. You can change the
mapping of port structures by applying a mapping on the link that connects two
components.
Adaptable port structure and mapping
When adding and connecting components to a project, Sybase IQ ETL
normally tries to create a standard mapping between an OUT-port and an IN-
port, depending on the object definition of data providers and data sinks. You
can modify the mapping by adding attributes to the port structure that can be
referenced immediately inside the component.
Running a project
Use simulation and execution modes to run a project.
Simulation and execution perform all functions of the components included in
the simulated project, including the physical transfer of data into the respective
data targets (data sinks).
During simulation you can step through the project component by component.
The data flow is visible on any link and within any component included. From
simulation mode, you can inspect any component and modify mappings and
calculations. After making changes, you can re-initialize the component with
the new settings and step to the next component. There is no need to start the
simulation from the very beginning of the project after any of the components
have been changed.
Jobs can be executed from the desktop or as a scheduled task.
Customizing a project
You can create data transformation projects without manually entering a single
line of programming code or SQL statement, for example: