Loading Trasaction And Master Data

Hi Eperts,

I have doubt about data extraction from external source.

My External source (flat file) contains some mater data as well as transaction data in one table. I want to load transaction data from that file to my fact table and (If any amendment ) master data to my master data table.

is it possible through single extraction process.

suggestion required.

Regards,

Aniruddha