Types of system SQL templates - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29

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 None
Rollback Sends a Rollback instruction to RDBMS. tSQLTemplate tSQLTemplateAggregate tSQLTemplateCommit tSQLTemplateFilterColumns tSQLTemplateFilterRows tSQLTemplateMerge tSQLTemplateRollback None
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