3 Replies Latest reply: Dec 13, 2012 5:43 AM by Astr0 RSS

    passing parameters into a .ctl file

    Astr0
      Hi,

      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.

      ~Astr0

      Edited by: 976696 on Dec 13, 2012 1:19 AM