User`s guide

Creating your first project
24 Sybase IQ ETL 4.1
Your project should now consist of two components. The link between the
components had been created automatically (provided the setting Create
Automatic Link When Components Are Added has been activated in your
Sybase IQ ETL Development preferences). If the line has not been
automatically created, you can easily draw one by clicking on the output port
and dragging it onto the input port of the Data Sink.
The outgoing port (OUT-Port) of the DB Data Provider Full Load component
and the ingoing port (IN-Port) of the DB Data Sink Insert component are both
displayed in green. This indicates that both components have been completely
configured (in other words, all required information has been provided).
In the Property section for the DB Data Sink Insert component, you can review
and set all properties of the selected component.
❖ To review and set properties for a component
1 Right-click the connecting line (the Link) between the components. The
line changes to the color green and a pop-up menu appears.
2 Select the Mapping command.
The mapping between the data source and the target source has been created
automatically. To change mappings, select the connecting line and attach it to
another connection point.
Note You can only map to an unassigned target connection point. If all target
connection points are already assigned, you can easily free a target connection
point by selecting and deleting the mapping line that is currently linking to it.
Adding a data calculator
❖ To add a data calculator
1 Click the Transform tab in the Component Store.
2 Select the Data Calculator Java Script component and drop it onto the link
connecting the existing components. The color of the link changes to blue.
After releasing the Data Calculator component:
• The Data Calculator component is linked with the components to the
right and to the left.
• The Data Calculator window appears.