Add join conditions to specify the relationship between data sources. You can create join conditions for a data source with any other data source in the previous rows.
Select the data source in the
Join View Editor
dialog box appears.
Select the alias name of any of the data source in the previous rows.
Select the left field of the join condition.
The left field of the join condition consists of the output fields from the alias name you choose. You can also configure and validate a PowerCenter expression as the field. When you enter a field name in the expression, append the alias name followed by an underscore. For example, if the alias name of the table is customer1 and you want to use the CustIDfield in an expression, enter the expression as customer1_CustID > 100.
Select the right field of the join condition.
The right field consists of the output fields of the data source for which you configure the join condition. You can also configure and validate a PowerCenter expression as the field.