12.3.10 Derived Column

This section provides information about the Derived Column component.

1. Drag and drop Derived Column component on the canvas.
2. To position the component on the canvas, drag and move the component, or click the component and use arrow keys on the keyboard to move it around.
3. Connect the output of the Derived Column component to the Mapping component.
4. At any given time, right-click the component and select the relevant options to either delink, remove inlinks or outlinks, or delete the component.
5. Double-click the Derived Columncomponent and click Add to define a new derived column.
6. On the right pane, under Entities, double-click to select the entities which you want to use to build the expression. The selected entities appear in the Expression field at the bottom. Modify the expression based on your needs. Provide the Name for the derived column.
7. Click Validate to verify the correctness of the SQL Expression.
8. Click Apply. The saved details appear as a list on the left pane.
9. Click the Edit button to modify the name and expression of the required Derived Column.
10. Repeat the steps to create as many Derived Columns as you require.
11. Click Ok.