Port Structure Configuration

All data in a project flows through component ports called IN-ports, which receive data, and output ports, which pass the data after processing. Each port owns the structure of the data flow. You can change the port structures of all components for which the structure is not directly dependent on component configuration. You can reference attributes added to the port structure immediately inside the component.

When connecting components, Sybase IQ InfoPrimer attempts to create a standard mapping between the output port and the input port. You can modify the mapping on a connection in the Mapping window. by right-clicking the connecting link, and selecting the Mapping option.

An unstructured port inherits the structure of a structured port, when a connection is added between them. You can add attributes to a port structure.

After you add a component to the project, the color of the component ports indicates the status of the component:

Green – component is properly configured.
Yellow – the port structure is defined but one or more mandatory properties are not defined.
Red – no port structure is defined, but one or more mandatory properties are not defined.

Note:

To enhance support for users with color disabilities, you can change the color of the yellow component port by selecting Use enhanced color accessibility in the File > Preference window.

Modifying Port Structures
Modify port structures using Structure Viewer window. If a port structure cannot be modified, the Edit Structure option is unavailable; you can only view the port structure using the View Structure option.
Adding Port Attributes
Add port attributes to all port structures participating in a selected connection.
Deleting Port Attributes
Use the Structure Viewer window to remove port attributes.
Modifying Port Attributes
Use the Structure Viewer window to modify port attributes.
Copying Port Structures from Other Ports
You can assign a port structure to a port based on any other available port in the current project.
Updating Port Structure with Database Changes
Apply database changes to the port structure of components.
Selecting a Port to Serve as the Source for your New Port Structure
Choose a source port for your new port structure.

Parent topic: ETL Components