Configuring metadata for the Reader Edge

The Edge component (between the Reader and Reformat components) has to be associated with a Metadata definition so it knows what fields of data are being passed from the Reader component to the Reformat component.

1. Right-click on the Edge and select New metadata > Extract from flat file.
2. Select New metadata > Extract from flat file. The Flat File dialog is displayed.
3. In the Flat File dialog, click the Browse button, which brings up the URL Dialog.
4. In the URL Dialog:, double-click the data-in folder, select the FactSales.csv data source file, and click OK. As a result, the Flat File dialog is populated with source data from the data file.
5. In the Flat File dialog, make sure that the Record type field is set to Delimited and then click Next. The Metadata Editor is displayed, as in the example above.
6. In the middle pane of the Metadata editor:
   1. Check the Extract names box.
   2. Click Reparse.
   3. Click Yes in the Warning message.
7. In the Record pane of the Metadata editor, make these changes:
   1. Click the Record Name field and change the default value to a name that is appropriate for your data, such as FactSales for the sales transactions data set. In this example, Record:FactSales will be the resulting Name value.
   2. If your source data has date properties, you should set their type to date (the type may be set to string by the Designer). Then use the Format field (in the Field pane on the right) to set the appropriate value, as in this example:

      

   3. Verify that the other properties have their property type set correctly. For example, change the FactSales_UnitPriceDiscountPct and FactSales_DiscountAmount property types from integer to number in our sample metadata.
   4. Verify that all properties have the correct delimiter character set (which is the comma character in our source data).
   5. When you have input all your changes, click Finish.
8. Save the graph.