filter in informatica

• Active Transformation

• Used to filter the data or reduce the amount of data.

• Single condition can be applied at a time.

• Filter transformation accepts only two types of data - Boolean (True or False)

• Filter accepts condition satisfied data.

• The false data is rejected or dropped to the bad files. (Drawback)

Scenario 1: More than on targets.

We can’t combine multiple conditions in one filter 

Scenario 2: Only one target.

Here we can combine multiple conditions in one filter using logical operators (AND, OR)  

      

Steps to use Filter Transformation