How to load only the first and last record of a flat file into the target?

Question

Design a mapping to load the first record from a flat file into one table A, the last record from a flat file into table B and the remaining records into table C?

Answer 1

we can write the shell script for it
head -1
tail -1
we call it either in command task or pre and post session shell commands in session

or-

using Aggregator trans FIRST and LAST funtions we can pass first and last record