Load data from multiple data files into multiple tables using single ctl file

Question

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 respectively. 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.

astrob0t · Accepted Answer · 2012-12-14 04:07:14Z

2

using 1 ctl file there exists four combinations.

insert data from multiple data files to a single table
insert data from a single data file to multiple tables
insert data from single data file to single table
insert data from multiple files to multiple tables.

the first three are possible for any situation. but the fourth case is possible only when the structure of all tables is the same. otherwise we have to go for multiple ctl files.

more info can be found here

answered Dec 14, 2012 at 4:07

astrob0t

1431 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Load data from multiple data files into multiple tables using single ctl file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related