To create a schema for a comma-delimited file, use the
Import CSV Wizard in the Schema Editor.
- Select Schemas/ CSV (Comma Delimited File) from the menu.
The Generate Schema for a CSV File dialog appears.
- Enter a unique Service Name and the name of the CSV File. (Clicking the ... button displays a file selection dialog box.)
- If the sample CSV file contains field headers in the
first row, check the First Row contains column headers check box. The field
headers are used to create the attributes in the schema.
Otherwise the attribute names are
FIELD1,
FIELD2, etc..
- Click Generate.
- A schema is generated in the schema editor. You may now
use the Schema Editor to edit the schema as with any other
type of schema.
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.