Setting the Import Format Data Types

When loading data, specify the type of data for the import format:

• Delimited–Numeric data

• Fixed–Numeric data

• Multi-Column–Numeric Data

• Delimited–All Data Type

• Fixed–All Data Type
• Multi Column–All Data Type

1. On the Setup tab, under Integration Setup, select Import Format.
2. In the Import Format summary task bar, select Add.
   In the upper grid of the Import Formats screen, a row is added.
3. In Name, enter a user-defined identifier for the import format.
   You cannot modify the value in this field after a mapping has been created for this import format.
4. In Source, select the source system.
5. In Target, select the target system.
6. In Description, enter a description of the import format.
7. In Import Format, in File Type, select the type of non-numeric data file.
   Options include:

   • Fixed - Numeric Data

     See Defining Import Formats for File-Based Mappings.

   • Delimited - Numeric Data

     See Defining Import Formats for File-Based Mappings.

   • Multi Column - Numeric Data

     See Loading Multi-Column Numeric Data.

   • Delimited - All Data Type

     See Setting the Import Format Data Types.

   • Fixed - All Data Type

     See Setting the Import Format Data Types.

   • Multi Column - All Data Type

8. If the file type is delimited, in the File Delimiter field, select the type of delimiter:
   • comma (,)
   • exclamation (!)
   • semi-colon (;)
   • colon (:)
   • pipe (|)
   • tab
   • tilde (~)
9. In Drill URL, enter the URL used for the drill-through.
10. In the Mapping section, map any dimensions.
11. Add the import format expressions.
12. Click Save.