INTERSECT Operation

The INTERSECT operation enables you to manipulate the data coming from different datasources. Follow these steps to add and configure an INTERSECT operation in the data flow:

1.

INTERSECT operation should have at least two data inputs on which the operation can be performed. Drag the Intersect node towards the node to which you wish to connect it to.

2.

Once the INTERSECT operation is successfully added to the data flow diagram, the Intersect Configuration pane is displayed below the canvas. All the columns from both the data inputs are displayed. Click on the + button next to the column to add the INTERSECT operation and X button to delete it. You also have the option to do a “INTERSECT ALL” as well to “Auto Match the Columns”.

3.

The data preview pane on the right displays the result set data.

Features and Limitations of the INTERSECT Operation

•

The INTERSECT operation can have unlimited inputs. But there must be at least two inputs and can have only one output.

•

This operation can be added after any operation except the Publish operation.