Creating a Dimension from an ASCII File

To create a dimension using the example.cma sample file:

Procedure

  1. In the left pane of the Server Explorer, select Processes beneath the local server.
  2. Choose Process, Create New Process.

    The TurboIntegrator window opens.

  3. Select Text as the Data Source Type.
  4. Click the Browse button for the Data Source Name and select example.cma in your TI_data directory.
  5. Leave the Data Source Name on Server field empty.
  6. Set the Delimiter Type to Delimited and the Delimiter to Comma.
  7. Disregard the Quote Character and the Number of Title Records fields, as there are no quotes and no title records in the input file.

    The Decimal Separator should be period (.) and the Thousand Separator should be comma (,).

  8. Click the Preview button to view records from the example.cma source file. These records let you examine the structure of records in the data source.