User`s guide

Content Explorer
46 Sybase IQ ETL 4.1
The examples in this chapter open the project Demo Getting Started from the
Demo Repository.
Opening Content Explorer
To open Content Explorer, select Content Explorer from the Tools menu. The
Choose Data Source dialog box appears and lists all components currently
connected to data sources.
The names in the list of currently connected databases is a combination of a
user defined name and the generic name of the component type.
Double-click the line to open the Design window of the Content Explorer. The
examples in this chapter are based on the DB Data Provider - Full Load
component in the project Demo Getting Started from the Demo Repository.
In the Table Catalog on the left, you can directly browse the content of an
object selecting Browse from the pop-up menu.
Using the Design area
The Design area is part of a graphical user interface that enables you to
automatically generate
SELECT statements that are more specific about the
records you are interested in.
From the Design area, you can:
• Drag objects from the Navigation area into the Design area
• Select attributes to be used in the
SELECT/WHERE/GROUP/ORDER BY
clause
• Graphically create joins between tables using SQL 92 join operators