Filter Transformation is an active transformation which is used to restrict the data based on the given condition. If the given condition is satisfied only those rows will be sent to the trget, others will be rejected. The default condition of filter is “True”, which means all the input will be sent to the output.
Creating Filter Tranformtion
- In the mapping designer-> Mappings->Create new Mpping
- Go to transformation->Create->Select Filter Transformation->Specify name->Create->Done
- Right click on Filter transformation->Edit
- Here we can configure the filter trnsformation.
Properties: Here we can specify filter condition
Metdata Extensions:Specify metadata details like name, datatype, etc.
Transformation:We can enter name and description of the Transformtion.
Metdata Extensions:Specify metadata details like name, datatype, etc.
Transformation:We can enter name and description of the Transformtion.
Note
•Multiple conditions are not possible in Filter Transformation.
•Filter Transformation works like a where class.
Implementing Filter Transformation with example
Implementing Filter Transformation with example
- Drag source and target from repository to designer
- Go to transformaation->create->Filter->flt_emp->ok
- Copy all the ports from source qualifier to filter.
- Edit->Filter->Properties->Filter condition->sal>2000->validate
- Connect all the ports from filter to target.
