Step 7: Adding a Table Join operator.
步骤7：添加一个Tablejoin操作符。
The information needed can be obtained by using the SQL JOIN operator.
需要能够通过使用SQLJOIN操作符来获得这些信息。
You can tell the type of join (INNER, RIGHT, or LEFT) by the details of the join operator.
可以根据连接操作符的细节判断连接的类型(INNER、RIGHT或LEFT)。
Right-click the output port (Inner) of the JOIN operator, and select Create suitable table from the context menu.
右键单击JOIN操作符的输出端口 (Inner)，然后从上下文菜单中选择Createsuitabletable。
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也可以通过同时执行连接操作符的内分支和外分支而从异步中获益。
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。
Without asynchrony, the federated UNION operator initiates the blue leg first, waits for the remote join to complete, and retrieves its result set.
在没有异步的情况下，联邦union操作符首先开启蓝色分支，等待远程连接完成，然后获取它的结果集。
This operator extracts account ID values to drive a join operation that can produce the desired result set.
该操作符提取账户id值，以驱动一个连接操作，该连接操作可以产生所需的结果集。
TBSCAN (4) — Since this is the same join predicate being resolved at NLJOIN (2), and there are no additional local predicates, we can ignore this operator.
TBSCAN(4)——因为这个连接断言和NLJOIN(2)分析出的相同，并且没有其他局部断言，可以忽略该操作。
As such, the NLJOIN does not act as a classical join with two input legs, but facilitates access to the XML data for the XSCAN operator.
同样地，NLJOIN并没有充当拥有两个输入的标准连接，而是协助XSCAN操作符来访问XML数据。
IT then reads from the outer table BAD_CREDIT using the SHIP operator, hashing the join column values, and checking in the lookup table generated for the inner table.
然后，它使用SHIP操作符读外表BAD_CREDIT，散列连接列的值，并检查为内表生成的查找表。
Start from the leftmost deepest operator, in this case, the OUTER of NLJOIN(2) which is TBSCAN(2), and the INNER which is TBSCAN(4), and then the join predicate itself which is NLJOIN(2).
从最左侧、最深的操作开始，在这里就是NLJOIN(2) 的OUTER即TBSCAN(2)，然后INNER 即 TBSCAN(4)，最后是连接断言本身即 NLJOIN(2)。
If the join key is a composite key, each key column must be prefixed with the PRIOR operator.
如果联接键是一个复合键，那么必须使用PRIOR运算符为每个键所在的列加上前缀。
In the Join dialog box change the comparison operator between the primary keys as required.
如有需要，在[联结]对话方块中变更主索引键之间的比较运算子。
Join dialog box, you can specify a join based on a different operator, and you can specify an outer join.
“联接”对话框中设置选项，可以基于不同运算符指定联接，并且可以指定外部联接。
Join dialog box, you can specify a join based on a different operator, and you can specify an outer join.
“联接”对话框中设置选项，可以基于不同运算符指定联接，并且可以指定外部联接。
应用推荐