Database Reference
In-Depth Information
Join condition
Join conditions are the most important condition to join the data. To define the join condi-
tion, you need to have a common port in both the sources. Also, make sure the data type
and precision of the data you are joining is same. You can join the data based on multiple
columns as well. Joining the data on multiple columns increases the processing time. Usu-
ally, you join the data based on key columns such as the primary key/foreign key of both
the tables.
Joiner transformations do not consider
NULL
as matching data. If it receives
NULL
in the
data, it does not consider them to be matching.
To define a join condition, double-click on the Joiner transformation, click on the
Condi-
tion
tab, and define the new condition.
You can define multiple conditions to join two tables.
