|
-
I have some 25 input CSV files which has over 30 coulumns in each input CSV file.
for example if i start writing control file like this ..
LOAD DATA
APPEND
INTO TABLE emp
(empno POSITION(01:04) INTEGER EXTERNAL,
ename POSITION(06:15) CHAR,
job POSITION(17:25) CHAR,
mgr POSITION(27:30) INTEGER EXTERNAL,
sal POSITION(32:39) DECIMAL EXTERNAL,
comm POSITION(41:48) DECIMAL EXTERNAL,
deptno POSITION(50:51) INTEGER EXTERNAL
and so on for 30 coulmns then the effort would be too much to create 25 control files to load 25 tables.
I feel it would be better if i have one control file so that i can pass the table name as parameter and call the same control file in a loop.
PS: each table has unique column names.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|