Why filtering is used in transformations?
The Filter transformation filters data out of the data flow based on a specified filter condition. To improve job performance, place the Filter transformation close to mapping sources to remove unnecessary data from the data flow. A filter condition is an expression that returns TRUE or FALSE.