Projects are the working units of Sybase IQ ETL. A project consists of components and links, which connect components through their ports. There are basic operations that involve projects (such as creating, deleting, renaming, saving) and there are complex operations like simulation.
A Sybase IQ ETL project starts with one or multiple source components and ends with one or more destination components.
The following list summarizes the components:
A Data Provider component is usually connected to a Transformation component, a Processing component, or a Data Sink component.
Transformation components and Processing components have input and output ports and can have adjacent components of any type.
If a Transformation component allows multiple input data streams, multiple originating Source components are required.
If a Transformation component has more than a single output of data streams, each data stream can be connected with a component.
Select New | Project from the File menu. You can also right-click a project, job, or template in the Navigator and select New | Project.
Drag components from the Component Store onto the Design section as your project requires it.
To execute a project, right-click the project in the repository and select Execute from the pop-up menu.
To modify a project, double click the project name in the Navigator section. The project opens and you can make changes.
If a project is locked by another user client, the project can generally be opened in read-only mode. To make a project available for read/write access, select Unlock.
To copy a project or job, you can select it from the Navigator tree, right-click, and select Save as or select Transfer. Then, select the target repository session.
If you select Save As, you create a copy of an existing project or job, leave the original untouched, and store no reference to the originating project or job.
If you select Transfer, you copy the complete project from one repository to another and reference the originating project. Select Transfer if you want to move a project or job from a development repository to a test or production repository. By storing the references to its origins, the transfer recognizes the project or job the next time it is initiated and selectively replaces everything related to the incoming object. Transferring a job also transfers all projects related to the job.
The Delete command deletes a project from a repository. To delete a project, right-click it in the Navigator section and select Delete from the pop-up menu.
Use the Rename command to rename the current project.
Resets the current value of the Load Index Value (DB Index Load component). This is used for resetting loading options for incremental load.