You can tell the type of join (INNER, RIGHT, or LEFT) by the details of the join operator.
可以根据连接操作符的细节判断连接的类型(INNER、RIGHT或LEFT)。
Generate the expression for the join predicate by applying the join operator to the expressions for the left and right attributes.
将联结操作符应用于左右属性的表达式，从而产生联结谓词的表达式。
As with the UNION operator, the join operator itself remains synchronous and is only able to process input from one leg of the join at a time.
和UNION操作符一样，连接操作符本身是同步的，每次只能处理来自连接操作符某一个分支的输入。
In a subsequent data flow operation, you'll use a join operator to ensure that full XML account records (contained in the INFO column) are fed into the target data warehouse table.
在随后的数据流操作中，您将使用一个连接操作符确保整个XML账户记录(包含在info列中)被填充到目标数据仓库表中。
Join operators such as HASH, MERGE SCAN and (in some situations) NESTED LOOP can also benefit from asynchrony by simultaneously executing the inner and outer legs of the join operator.
MERGESCAN等连接操作符和(在某些情况下)NESTEDLOOP也可以通过同时执行连接操作符的内分支和外分支而从异步中获益。
Step 7: Adding a Table Join operator.
步骤7：添加一个Tablejoin操作符。
The information needed can be obtained by using the SQL JOIN operator.
需要能够通过使用SQLJOIN操作符来获得这些信息。
Right-click the output port (Inner) of the JOIN operator, and select Create suitable table from the context menu.
右键单击JOIN操作符的输出端口 (Inner)，然后从上下文菜单中选择Createsuitabletable。
Specify the condition for the table Join operator by connecting the tables using the unique term number, which is SKILL_ID in the result set of the text analysis and TERM_ID in the taxonomy table.
通过使用唯一的术语编号将表连接起来，为TableJoin操作符指定条件，术语编号为文本分析结果集中的SKILL_ID，和位于分类表中的TERM_ID。
Specify the condition for the table Join operator by connecting the tables using the unique term number, which is SKILL_ID in the result set of the text analysis and TERM_ID in the taxonomy table.
通过使用唯一的术语编号将表连接起来，为TableJoin操作符指定条件，术语编号为文本分析结果集中的SKILL_ID，和位于分类表中的TERM_ID。
应用推荐