User`s guide

CHAPTER 6 Components
User’s Guide 81
In Display structure mode, all attributes of the connected port and their current
mappings are shown. The Display structure and values mode displays the value
of the current record.
❖ To change a mapping
1 Click on a connecting line.
2 Remap it to a new port attribute by dragging the line end to a new
connection point. (See “Viewing current mappings” on page 31.)
Source components
DB Data Provider Full Load
The Data Provider Full Load component is one of the source components to
initiate the transformation process. Use this component whenever the source
database has a relational structure and is accessible through ODBC or Sybase
IQ ETL-provided native DB drivers (DB2, Oracle, Sybase).
This component retrieves data by issuing a query against the data source. The
structure of the (single) output port mirrors the structure of the query result set.
❖ To enter required properties
1 Enter the connection parameters as described in “Entering database
connection parameters” on page 71.
2 In the Property section, click Query to open the Enter Property window.
The Enter Property window allows you to enter and validate the query. The
skilled user might enter the SQL query directly into the Query field. The Query
Designer offers a graphical interface to create the SQL query.
Entering a query
To enter a query, enter the SELECT statement straight into the Query field. Any
valid
SELECT statement based on the underlying database system and schema
is allowed. No delimiting character to mark the end of the statement is required,
for example:
SELECT * FROM CUSTOMERS