Data Loader configuration file

The configuration file (.CFG) defines the layout of the data file. It is composed of option lines and configuration lines. Collectively, these lines define how each line in the data file should be loaded into the database. This ability allows for maximum flexibility in the layout of the data file.

Line type Syntax Example
Option
#<option>=<value>
#Delimiter=','
#Fact_Table='local'
Configuration
<dimension | Ownership_Property>,<ID | Name>, <location in data file>
Year,Name,1
Schedule,Name,2
Unit,ID,3
Unit,Name,4
Period,<value>,<location in data file>
Period,January,7
Period,February,8
Period,March,9