How to remove Null values using Filter Transformation?

In the Filter Transformation you can filter out rows having null values and spaces by using ISNULL and IS_SPACES functions.

For example , to filter out rows that contain null in EMP_NAME column us the below condition

IIF(ISNULL(EMP_NAME),FALSE,TRUE)

This condition says that if the Employee name is null then discard the row else pass it to the next transfomation