Difference between Router and Filter transformations?

1. We cannot pass rejected data forward in filter but we can pass it in router. Rejected data is in Default Group of router.
2. Filter handles single condition where as Router handles multiple conditons.
3. Filter has single target and Router has multiple targets.
4. Filter has no default group.

Continue Reading...

How to filter out rows with null values?

To filter out rows containing null values or spaces, use the ISNULL and IS_SPACES functions to test the value of the port. For example, if we want to filter out rows that contain NULLs in the FIRST_NAME port, use the following condition:

IIF(ISNULL(FIRST_NAME),FALSE,TRUE)

This condition states that if the FIRST_NAME port is NULL, the return value is FALSE and the row should be discarded. Otherwise, the row passes through to the next transformation.

Continue Reading...

Filter transformation

Filter transformation is an active and connected transformation.

Using the Filter transformation, we can filter rows in a mapping. We pass all the rows from a source transformation through the Filter transformation, and then enter a filter condition for the transformation. All ports in a Filter transformation are input/output and only rows that meet the condition pass through the Filter transformation.

Working with the Filter Transformation...

• Import Source and Target.
• Then create Filter transformation.
• Edit Filter Transformation. Go to Properties Tab
• Click the Value section of the Filter condition, and then click the Open button.
• The Expression Editor appears.
• Enter the filter condition you want to apply.
• Click Validate to check the syntax of the conditions you entered.

Tip: Using the Filter transformation at the source side for the best performence because only the filter rows pass to the next level of transformation.

Continue Reading...