Acts on the actual DB structure or on the data (although without handling data).
tVerticaRow is the specific component for this database query. It executes the SQL query stated onto the specified database. The row suffix means the component implements a flow in the job design although it does not provide output.
The SQLBuilder tool helps you write easily your SQL statements.
For more technologies supported by Talend, see Talend components.