Filter transformation is connected and active transformation. It is used to filter out the unwanted rows from loading into our target. In order to filter out the rows we have should specify the condition in the filter transformation. If the condition is true rows will be passed to other transformations. If the condition is false rows will not be passed to other transformations.
Steps to create filter transformation :-
- In the mapping designer, open a mapping or create a new mapping.
- Go to the toolbar->click on Transformation->Create->Select the filter transformation
- Enter a name->Click on create and then click on done.
- You can add ports either by dragging from other transformations or manually creating the ports within the transformation.
Steps to create filter transformation :-
- In the mapping designer, open a mapping or create a new mapping.
- Go to the toolbar->click on Transformation->Create->Select the filter transformation
- Enter a name->Click on create and then click on done.
- You can add ports either by dragging from other transformations or manually creating the ports within the transformation.
No comments:
Post a Comment