Tuesday, February 23, 2016

Filter Transformation Informatica

1. Filter

Ø  The Filter transformation allows rows that meet the specified filter condition to pass through it.
Ø  It drops rows that do not meet the condition
Ø  Filter condition returns either TRUE or FALSE for each row.
Ø  The rows with filter condition that returns TRUE will pass through the filter
Ø  The rows with filter condition that returns FALSE will be discarded from mapping flow.
Ø  All the input ports to filter transformation should come from a single transformation only.
Ø  ZERO(0) evaluation at the filter condition will be consider as FALSE
Ø  Any Non zero value will be consider as TRUE
Ø  TRUE and FALSE are implicit return values from any condition you set.
Ø  If the filter condition evaluates to NULL, the row is treated as FALSE
Ø  filter condition is case sensitive, so be careful while defining conditions which involves string constants  The below string constants are not equal
 Hyderabad , HYDERABAD, hyderabad
Ø  Rows with NULL or SPACES in particular column can be filtered by defining the condition as
   IIF(ISNULL(first_Name), FALSE, TRUE)
Ø  You can define simple and complex(compound) filter conditions, the complex filter conditions may contain the logical operators AND, OR , NOT
Ø  When defining a filter condition which involves ports with String data types the the string values should be enclosed in single Quotes ('')
Ø  When defining a filter condition which involes date port you have to define format specifier as below according to you source input port data format
Example Date format Specifiers : DD-MM-YYYY , DD-MON-YYYY, MMDDYYYY, YYYYMMDD
Ø  Filter transformation can be used to filter data coming from non relational and relational sources.

No comments:

Post a Comment