sql loader master-detail
Hi,
I need to load a pipe delimited flat file containing denormalized data as shown below into a master - detail table. I know how to call a database sequence to make the join between the two tables, but would like to know how to create the control file so that multiple detail records can be loaded for one master record. For this example, let's say the name of the master table is master_tab and the name of the detail table is detail_tab and the name of the sequence is my_seq. The data file would like very similar to the