| Filter transformation is a active transformation. |
| The Filter transformation allows you to filter rows in a mapping only rows that meet the condition pass through the Filter transformation. |
| |
| Filter performance: |
| |
- Use the Filter transformation early in the mapping.
- Use the Source Qualifier transformation to filter.
|
| Note:: The Source Qualifier transformation only lets you filter rows from relational sources |
| |
| Important :: |
| |
- Case sensitivity. The filter condition is case-sensitive
- Appended spaces .Use the LTRIM or RTRIM function to remove additional spaces.
|
| |
| Condition Examples:: |
| |
|
- SALES >30 and LOC='INDIA'
|
- IFF(ISNULL(NAME),FALSE,TRUE)
|
| |
| |
