-
SQL Loader...how to skip fields in data file
Hi
I've a data file delimited by ~
a~b~c~d~e
and i'm loading the file into a table X with columns
cola
colb
colc
cole.
Here I don't want to load the data d into my table. I want to skip the filed d of the data file and load data e into the column cole.
Please suggest me , how to achieve this. I can't change the format of the datafile
Thanks,
Sajeev
-
In your control file you can specify the locations of the field to be loaded. Just don't specify 'd'. It is easier in fixed format files than CSVs, but check the docs.
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
-
Ican't specify the field position in control file. The table doen'thave any column like that. And its not a fixed length format..
Sajeev
-
Look at example 5-5 in the documentation (Using Filler Fields.)
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
-
That's it.. It worked.
Thanks
Sajeev
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
|