User`s guide

Understanding repositories
4 Sybase IQ ETL 4.1
• To generate SELECT statements inside Queries, Lookup Definitions, Pre-
and Post Processing SQL, use the Query Designer.
• To freely map attributes between data sources and data sinks, use the data
mapping features of the links between the components.
• To create temporary or persistent staging tables, use the built-in
Create
Table from port
command of the respective component.
• To create tables in the destination database, use the built-in
Create Table
from port
command of the respective component.
• To browse both schema information and data content of all connected data
sources, use the Content Explorer.
• To read hierarchical XML documents and generate a relational structure
automatically, use the XML from the SQL component.
• To schedule the execution of your projects, you can create Jobs within the
Sybase IQ ETL Development desktop.
To deal with complex data transformation requirements, familiarize yourself
with Sybase IQ ETL Development concepts.
For example, you can:
• Use manually optimized SQL
SELECT statements to adjust and fine-tune
your data extraction process.
• Use SQL to apply data manipulation commands inside pre- and post-
processing commands.
• Use JavaScript to write procedures, do complex calculations, or
manipulate objects in the operating system environment.
• Use indirection in expressions (Square Bracket Notation) to dynamically
assign values to expressions to control your projects by using environment
or user variables.
Understanding repositories
The repository contains all data and information related to Sybase IQ ETL
objects, projects, and jobs.