Types of system SQL templates

Talend ESB Studio User Guide

EnrichVersion
6.5
EnrichProdName
Talend ESB
task
Design and Development
EnrichPlatform
Talend Studio

This section gives detail information related to the different types of the pre-defined SQL templates.

Even though the statements of each group of templates vary from database to database, according to the operations they are intended to accomplish, they are also grouped on the basis of their types in each folder.

The below table provides these types and their related information.

Name

Function

Associated components

Required component parameters

Aggregate

Realizes aggregation (sum, average, count, etc.) over a set of data.

tSQLTemplateAggregate

Database name

Source table name

Target table name

Commit

Sends a Commit instruction to RDBMS.

tSQLTemplate tSQLTemplateAggregate tSQLTemplateCommit tSQLTemplateFilterColumns tSQLTemplateFilterRows tSQLTemplateMerge tSQLTemplateRollback

Null

Rollback

Sends a Rollback instruction to RDBMS.

tSQLTemplate tSQLTemplateAggregate tSQLTemplateCommit tSQLTemplateFilterColumns tSQLTemplateFilterRows tSQLTemplateMerge tSQLTemplateRollback

Null

DropSourceTable

Removes a source table.

tSQLTemplate tSQLTemplateAggregate tSQLTemplateFilterColumns tSQLTemplateFilterRows

Table name (when use tSQLTemplate)

Source table name

DropTargetTable

Removes a target table.

tSQLTemplateAggregate tSQLTemplateFilterColumns tSQLTemplateFilterRows

Target table name

FilterColumns

Selects and extracts a set of data from given columns in RDBMS.

tSQLTemplateAggregate tSQLTemplateFilterColumns tSQLTemplateFilterRows

Target table name (and schema)

Source table name (and schema)

FilterRow

Selects and extracts a set of data from given rows in RDBMS.

tSQLTemplateAggregate tSQLTemplateFilterColumns tSQLTemplateFilterRows

Target table name (and schema)

Source table name (and schema)

Conditions

MergeInsert

Inserts records from the source table to the target table.

tSQLTemplateMerge tSQLTemplateCommit

Target table name (and schema)

Source table name (and schema)

Conditions

MergeUpdate

Updates the target table with records from the source table.

tSQLTemplateMerge tSQLTemplateCommit

Target table name (and schema)

Source table name (and schema)

Conditions