hi,
I have a single datafile containing data for multiple tables. Data for each table is identified by a different record type
egs
(datafile.txt)

A 1001name1 age1
B 20 deptname

In the above datafile, I need to take A.... into emp table
and
B .... into dept table.

What changes should I make in the control file to write the data into multiple tables

Please help me
Badrinath