Mind map
FILTER Transformation
Map content
FILTER Transformation
ACTIVE
Filter Condition
- TRUE - passes data
- FALSE - drops data & writes message to session log
- Example: SALARY > 3000 AND SALARY < 1000
- NULL is FALSE
- ISNULL or IS_SPACES to test value of the port IIF (ISNULL(field),FALSE, TRUE)
use early in mapping; any type of source ; can use any statement or transformation function that returns TRUE or FALSE
Information
- Description
- Mind Map on FILTER Transformation, created by v_krejci on 02/11/2015.
- Created by
- v_krejci
- Views
- 0
- Rating