Transformer Stage to filter the data

If our requirement is to filter the data department wise from the file below 

samp_tabl 
1,sam,clerck,10 
2,tom,developer,20 
3,jim,clerck,10 
4,don,tester,30 
5,zeera,developer,20 
6,varun,clerck,10 
7,luti,production,40 
8,raja,priduction,40 

And our requirement is to get the target data as below 

In Target1 we need 10th & 40th dept employees. 

In Target2 we need 30th dept employees. 

In Target1 we need 20th & 40th dept employees. 

Take Job Design as below 
 



Read and Load the data in Source file 

In Transformer Stage just Drag and Drop the data to the target tables. 

Write expression in constraints as below 

dept_no=10 or dept_no= 40 for table 1 

dept_no=30 for table 1 

dept_no=20 or dept_no= 40 for table 1 

Click ok 

Give file name at the target file and 

Compile and Run the Job to get the Output 

Read more about Transformer Stage with example 

Leave a Reply

Your email address will not be published. Required fields are marked *