Other files or user XML

To create new data formats for a delimited flat file:

  1. Click Format Designer on the toolbar.
  2. From the File menu select New or click Create a new Format on the toolbar. The New Format dialog is displayed:
  3. 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.
  4. Click OK. Script view is displayed.
  5. 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.
  6. From the File menu, select Save Format or click Save a Format to save the data format.
  7. 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.