Insert and connect a Joiner transformer.
Click 
A wizard allows you to set the connection type, data source, connection parameters, and key field properties.
The Joiner transformer queries a database (which can be Access MDB files, ODBC connections, Oracle 7 and 8 attribute tables, CSV or DBF) to retrieve attributes associated with a feature.
One or more feature attributes are joined to one or more columns in the database, and the values from the matching database table row are added as feature attributes.
Insert and connect a Joiner transformer.
Click
A wizard allows you to set the connection type, data source, connection parameters, and key field properties.
Note: An optional prefix can be added to all the attributes retrieved from the database to allow repeated joins to the same database table to store their results into unique attributes.