I have 3 data files and 3 staging tables. Is there any way to enter the data from the data files to their respective staging tables using only a single control file using parameters.
To detail out the scenario, there are 3 data files namely A.dat, B.dat, C.dat whose data are to be entered into A_Stg, B_Stg,C_Stg staging tables. This can no doubt be done using separate ctl files. But the requirement is to do it using a single loader file.
Any pointers in this direction would be great.
Edited by: 976696 on Dec 13, 2012 5:15 PM redirected from [url https://forums.oracle.com/forums/thread.jspa?messageID=10744651�]here