To enter file properties:
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. |
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.
Optional: To remove spaces in the load file, select Remove White Space.
Optional: If you do not want transaction logs to be created, select Suppress Transaction Logs.
Now you will map the dimensions, as described in Mapping Dimensions.