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.
Enter the connection parameters as described in “Entering database connection parameters”.
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.
To enter required properties