Cholleti Kiran Kumar

• Apr 27th, 2006

 

            For example u have a table Emp_Name and it has two columns Fname, Lname in the source table which has douplicate rows. In the mapping Create Aggregator transformation. Edit the aggregator  transformation select Ports tab select Fname then click the check box  on GroupBy and uncheck the (O) out port. select Lname then uncheck the (O) out port and click the check box on GroupBy. Then create 2 new ports Uncheck the (I) import then click  Expression  on each port. In the first new port Expression type Fname. Then second Newport type Lname. Then close the aggregator transformation link to the target table.

 

Regards

Cholleti Kiran Kumar