Mapping Files

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. Select File Options.
3. 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 Drill URL, specify the URL used for the drill-through.
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 for Oracle Enterprise Performance Management Cloud.
6. 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.

   

7. Click Next.