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.