Loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. The project object will be passed in as the control file.
Object Type Identification
...
Object Type Code
SQL_LDR
Attributes
| Name | Description | Default Value | Supported Values | |
|---|---|---|---|---|
| Source | SOURCE | Object Source Location Type | SCM | SCM |
| Target Location | TARGET_LOCATION | Path to where the file should be deployed. | $<PROD_TOP>/bin/ | |
| Log File | LOG_FILE | Configuration file used to download/upload data. | loader.log | |
| Data File | DATA_FILE | Specifies the name of the datafile containing the data to be loaded. | ||
| Execute SQL Loader | EXECUTE_LDR | Should SQL Loader be executed | false | |
| Target File Permissions | FILE_PERMISSIONS | Permissions to apply to the file after it is deployed | Defaults to the project property FDEBS_FILE_PERMISSIONS |
Related Project Properties
...