Mapping with a FILTER Transformationĭefault condition for Filter Transformation is TRUE. Lets create a basic mapping with a Filter Transformation This is the source Table Records used for this mapping. # If the filter condition evaluates to NULL, the row is treated as FALSE. # The numeric equivalent of TRUE is ANY NON ZERO value. # The numeric equivalent of FALSE is zero (0) – Drop all the records. # Any expression that returns a single value can be used as a filter. # The filter condition is an expression that returns TRUE or FALSE. # Its an active and connected transformation. For each row that returns FALSE, the Integration Service drops and writes a message to the session log. For each row that returns TRUE, the Integration Services pass through the transformation. You can filter data based on one or more conditions.Ī filter condition returns TRUE or FALSE for each row that the Integration Service evaluates, depending on whether a row meets the specified condition. It drops rows that do not meet the condition. The Filter transformation allows rows that meet the specified filter condition to pass through. As an active transformation, the Filter transformation may change the number of rows passed through it. Use the Filter transformation to filter out rows in a mapping.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |