One file data into two tables using JBDC

Hi All,

I am getting a file which has multiple records... and the last record is status record always.....

Now i want to put multiple records in one table and the last status record in other table... How can i do this...?

I know that i can use JDBc receiver adaptor.... My question is in mapping can i map the source file datatype to two different datatypes for two different tables?

or can i do it in same datatype....? Like multiple tables names etc..

Thanks,