Contents of the Loader Parameters tab (Fig. ) depend on the Loader selection (see General Tab section). If load_file loader is selected, on this tab you set up the following parameters:
1. Delimiter – select from menu a character separating columns in the original source file.
2. Number of rows to skip – enter the number of lines taken by column headers in the original source file that should be omitted during the download to preserve the table’s integrity.
3. Convert Encoding Yes/No
4. Loader Enumeration Field – In the absence of the appropriate key, the system allows you to create a column that will be populated with a unique number for every record. Use the arrow button to enter the field that you want to contain consecutive enumeration. Usually, this feature is used to set up the Axiom Index field.
Note: If you use Axiom Index as the enumeration field, make sure to remove its value from the Original Column setup on the Original Data Configuration tab.
5. Trailing Null Columns in File Yes/No – This parameter is Oracle-specific. Consult DBA for details.
6. Generate Oracle Control File button – Oracle Control File is a script written for Oracle utility sqlldr. Pressing this button inserts the expression into the Control File pane. By default, the system will include all source columns. You can remove unwanted columns from the expression manually.
Note: Omit this parameter if you are not intending to modify the generated code.
7. Loader Control File – allows you to create Loader Control Files manually. The Lookup button opens the list of source columns.
Note: Loader Control File cannot include the Enumerator Field.
Note: The above parameters should be agreed upon with the data source provider in advance.
Note: Some loaders do not require any additional settings. In such cases, Loader Parameters tab will not appear as a part of the Source Editor.
– Set on No by default this parameter allows you to control whether during the Table update the old data will be replaced (No) or left untouched while only new data is written (Yes).