User`s guide

CHAPTER 1 Sybase IQ ETL
User’s Guide 5
Multiple repositories are accessible in parallel during a session. Projects can be
copied and transferred between repositories, so you can separate your
production repository from the repository used for development purposes.
A repository usually belongs to a single client (such as a department or firm).
It is possible to have more than one client using the same repository, providing
a complete logical separation within a single physical repository. Each client
can support any number of client users. Each user within a client has a user
name and a password that controls the access to information.
Converting datatypes and data formats
Datatypes as originated in the data source are preserved during the
transformation process.
Internally, Sybase IQ ETL distinguishes string and numeric datatypes. The
Standardize Data Format option of the Data Providers or Data Sinks
automatically converts the data to a standard format that then is automatically
converted to a format the target database understands. Therefore, you do not
have to deal with the various date and number formats when working with
different databases.
This setting is activated by default. However, if you are experiencing problems
with date or number fields, you can disable this setting on the component that
causes trouble and convert the data manually.
SQL
Most of the data delivered by data providers is defined by using SQL stored in
the
Query property. Sybase IQ ETL Development supports a modified set of the
SQL-92 standard.
If you do not want to get into the details of SQL-92, you can use the built-in
Query Designer to draw the query and have the SQL generated for you. If you
want to manually write SQL, or copy SQL from existing projects, you can
manually specify your SQL for the
Query property.