This section provides information about the Filter component.
Drag and drop the Filter component on the canvas to define a filter on an
entity such as EDD (Insert Connector)/ADI (Extract Connector).
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.
It accepts input only from an entity and can have only one output.
To have filters for multiple entities, drag and drop as many filters as the
number of entities you want to filter, connect each filter to its respective
entity, and then define their expressions. Example: To add a filter to three
entities, add three filters on to the canvas.
At any given time, right-click the component and select the relevant options to
either delink, remove inlinks or outlinks, or delete the component.
To define the filter expression, double-click filter component. The Filter
Expression Window is displayed. The selected entities and parameters are
displayed. Specify the required filter expression using columns and parameters.
Click Validate to verify the correctness of the SQL
Expression. Click OK.
You need not add the ‘WHERE’ clause for the filter.
Note:
For file data loading, use the filter expression of the
type Number along with single quotes. For
example: N_DRAWN_AMOUNT ='40000'.
For the Date field, see To_CHAR
function for comparison.
Parameters can also be used in the filter expression.
The date format must be a valid SQL Date Format.