Entering File Properties

  To enter file properties:

  1. In File Properties, select a column delimiter.

    You can select semicolon (;), comma (,), pipeline (|), space, or tab. Semicolon is the default.

    Note:

    The delimiter you select must be found in the file.

  2. Optional: To remove double quotes from a string, select Remove Double Quotes on Strings.

    If the flat file contains member formulas, deselect Remove Double Quotes on Strings to prevent quotation marks from being removed.

  3. Optional: To remove spaces in the load file, select Remove White Space.

  4. Optional: If you do not want transaction logs to be created, select Suppress Transaction Logs.

  5. Click Next.

    Now you will map the dimensions, as described in Mapping Dimensions.