Senario 4

Remove header and footer from your file 
Solution:

 We can remove header by skipping 1st row while importing the source but for footer we will have to implement a logic as follows:

• Use Expression Transformatin to assign Sequence no to each rows.

• Use Sorter after expression and sort on sequence no generated in expression transformation.
• as we have five footer lines use a filter after sorter and give condition where sequence no >5 
• finally connect to the target.