Can I use SQL Loader to insert records from a flat file into master and detail tables. I am having rows in the flat file for child table.
I have to insert one master record which will contain filename and time of upload and these details will go in master table. Detail table will have all records of flat file.
Also I would need to load them fast. Please let me know
Thanks in advance