Specifying File Options

You map files to specify the mapping type, drill URL, delimiter, and header row.

To map a file:

1. From the Data Integration home page, click to the right of a file-based integration, and then select General.

   The General page is displayed in "Edit Integration" view.

2. Click File Options.
3. From the File Options page, then from Type, select the data type of the file to load.

   Available types:

   • Delimited—Load numeric data from a delimited file format.

   • Multi-column–Numeric—Load numeric data for multiple dimension members of a selected dimension in a single row of data. The definition of the members to load can be included in a header record in the load file, or in the import format definition.

   • Delimited–All Data Type—Load all data types from a delimited file format.

   • Multi Column–All Data Type—Load all data types for multiple dimension members of a selected dimension in a single row of data. The definition of the members to load can be included in a header record in the load file, or in the import format definition.

   You can load data files that support the following data types:

   • numbers

   • text

   • Smartlists

   • date

4. In Encoding, specify the method for mapping bit combinations to characters for creating, storing, and displaying text.

   Each encoding has a name; for example, UTF-8. Within an encoding, each character maps to a specific bit combination; for example, in UTF-8, uppercase A maps to HEX41.

   Note:

   Oracle recommends you use the UTF-8 encoding and Pipe delimiters.
5. From Delimiter, select the character to use for delimiting columns in the output file.

   A delimited file contains one or more records set off from each other by a specified delimiter.

   Available options:

   • Comma (,)

   • Pipe (|)

   • Exclamation (!)

   • Semicolon (;)

   • Colon (:)

   • Tab

   • Tilde (~)

   Note:

   File encoding options are defined in the System/User Settings option in Data Management. For more information, see File Character Setting in Administering Data Management.
6. In Drill URL, specify the URL used for the drill-through.
7. From Use Head for Column Names, use the arrow keys to select a header row or no header row, and then click Next.

   To specify no header, select 0 in Use Head for Column Names.

   

8. Click Next.