Configuring the Reader Edge

The Edge for the Reader component must be configured with a Metadata definition.

This Metadata definition task will use the Metadata Editor. In the procedure, the column names will be extracted from the input file via a reparsing operation.

To configure the Metadata definition for the Reader Edge:

  1. Right-click on the Edge and select New metadata > Extract from flat file. The Flat File dialog is displayed.
  2. In the Flat File dialog, click the Browse button, which brings up the URL Dialog.
  3. In the Flat File dialog, browse for the PDR input file, select it, and click OK.
  4. In the Flat File dialog, click Next. The Metadata Editor is displayed.
  5. In the Flat File dialog, make sure that the Record type field is set to Delimited and then click Next. The PDR data is loaded into the Metadata Editor, with the properties named Field1, Field2, and so forth.
  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.
    The correct property names are now displayed in the upper and middle panes of the Metadata Editor, which should look like this example:

  7. In the upper pane of the Metadata Editor:
    1. Optionally, click the Record Name field and change the name of the metadata to a more descriptive name.
    2. Make sure that the Type field of all the properties is set to type string.
    3. Verify that the fields have the correct delimiter character set (which is the comma for our example).
  8. When you have input all your changes, click Finish.
  9. Save the graph.