1.Filter Transformation

 Filter is a active connected transformation it is applicable only for one condition i.e we can apply only one condition using filter,it is nothing but where in sql
It consists of 

Ports:-Input port,output port

Properties:-Filter Condition

 Scenario:-

  srce:emp

  tgt:emp_tgt

Requirement: need to load only deptno=10 values into target table 

  

 

After that create workflow and generate it  the o/p should be displayed as :

 

what are Passive Transformations?

The passive transformations are as follows:

1.Expression
2.Sequence Generator 
3.Lookup
4.Mapplet Output

what are the active transformations?

The active transformations are as follows:

1.Filter.

2.Router.

3.Lookup.

4.Joiner.

5.Sorter.

6.Rank.

7.Aggregator.

8.Router.

9.Mapplet Input.

2.Passive Transformation

Passive:             

 Transformations which does not change the number of rows passed through them, maintains the transaction boundary and row type are called passive transformation.