SQL Loader - insert into multiple tables

Hi Friends,  

      I have a text datafile in the following format  

Cln,cs001,04,Y

Cmp,cs001,45

Cmp,cs001,29

Cln,cs002,08,Y

Cmp,cs002,65

Cmp,cs002,80    

     Now i want to load all the records starting with 'CLN' into table1 and all the records starting with 'CMP' into table 2 using sql loader, what would be control file ?      

Thanks

Arvind Kumar

Associate Consultant
Siemens Information Systems Limited
e-mail : arvind.kumar2_at_siemens.com  

--
http://www.freelists.org/webpage/oracle-l