DatabaseJoin - 6.3

Talend Data Mapper User Guide

EnrichVersion
6.3
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
Talend Studio

Name

DatabaseJoin

Purpose

Specifies the conditions on a database join between two tables.

Description

The DatabaseJoin function may be used only as an I/O expression. Specify it as the I/O expression of the element that contains the data to be written.

This function specifies which columns are to be joined between the parent and child tables. It also specifies any selection criteria for the join.

Return Type

N/A (this function may be used only as an I/O expression)

Property

Where String

Enter a SQL condition as specified in a Where clause without the use of the word "Where".

Property

Join Type

Specify Inner to have the join exclude rows from the parent table with no corresponding rows in the child table. Specify outer to have all rows in the parent table included whether or not they are in the child table.

Argument

Parent Elements ([Map] Elements)

Specify the map elements corresponding to the columns in the parent table to be joined. These must be in the same order as the child elements.

Argument

Child Elements ([Map] Elements)

Specify the map elements corresponding to the columns in the child table to be joined. These must be in the same order as the corresponding parent elements.