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.
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.