Other files or user XML
To create new data formats for a delimited flat file:
- Click Format Designer on the toolbar.
- From the File menu select New or click Create a new Format on the toolbar. The New Format dialog is displayed:
-
Specify this information:
- Classification
- Select Other Files or User XML.
- Name
- Enter a unique name for the new data format.
- Description
- Enter a description for the new data format.
- Click OK. Text View is displayed.
-
Define the file schema by specifying a name and optional
description for each data element.
Note: The data elements must be defined in the same order as that used in Transformation Designer.
- From the File menu, select Save Format or click Save a Format to save the data format.
-
Validate and test the data format.
Note: If you have existing file schemas (.fsd file formats) you can copy and paste scripts in and out of Format Designer.