One Control-File für many Data-Files [message #193941] |
Wed, 20 September 2006 01:37 |
hfbm2004
Messages: 8 Registered: November 2005
|
Junior Member |
|
|
Hi,
we load every day 4 CSVs file with 4 different Loader-Control-Files:
file1.csv - > loader1.ctl
file2.csv - > loader2.ctl
file3.csv - > loader3.ctl
file4.csv - > loader4.ctl
file1.csv: field_1;...;field_100;name
file2.csv: field_1;...;field_100;name;city
file3.csv: field_1;...;field_100;name;city;country
file4.csv: field_1;...;field_100;name;city;country;region
The first 100 columns exist in all the 4 CSVs. All CSVs differ only in one or two fields.
Is it possible to load all the CSVs with only one Control-File?
Thenks in advance
Habib
[Updated on: Wed, 20 September 2006 01:45] Report message to a moderator
|
|
|
|