SQL-Loader:Loading Data into Multiple Tables

Loading Data into Multiple Tables

FLAT FILE:

1,"Nani","CSE","Final","A+"

2,"Indra Kanth","ECE","Final","B"

3,"Kalyan","CSE","Third","A"

4,"Praveen","IT","Third","B"

5,"Badra","ECE","Final","B+"

6,"Kali","EEE","Second","C"

7,"Giri","E&I","First","D"

8,"Sravan","MCA","Third","A"

9,"Pradeer","MCA","Second","D"

10,"Joe","CSE","Third","D+"

CONTROL  FILE:

load data

infile '/bin/flat_file11.txt' --Give your Flat file location

insert into table vnk_t1

fields terminated by ','

optionally enclosed by '"'

trailing nullcols

(

sno,

sname,

branch

)

into table vnk_t2

fields terminated by ','

optionally enclosed by '"'

trailing nullcols

(

year,

grade

)

Here we have a flat file named flat_file11 which is comma seperated file.The Control file loads the data in the flat file into two staging tables vnk_t1,vnk_t2.