In the Component Store, go to the Destination tab and select the DB Data Sink Insert component by dragging it into the project.
Select ODBC from the Interface drop-down list.
Select ETLDEMO_US from the Host Name drop-down list.
Click the selection button of the Destination Table property and select PRODUCTS from the table catalog.
Click Finish to confirm your settings.
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 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
Right-click the connecting line (the Link) between the components. The line changes to the color green and a pop-up menu appears.
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.
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.
