12.2.5 Defining an External Data Descriptor

To define a new EDD from the DIH Designer window, complete the following steps:

1. From the Data Ingestion summary page, click Add.
   The New tab is displayed.
2. Enter the name and description for the data descriptor, and then select Datastore from the drop-down list. This is the data source you had created. In this example, it is, ERP_FILE_EXTRACTS. The values in Defining an External Data Store example are used. The description comes up automatically.
3. Click Save as Draft or click Save.
4. Enter the values in the fields as described in the Fields and their Description. section.
5. If data needs to be reconciled post-loading, then click the Control tab. In this version, only the Number of Records controls is possible.
6. To transform the EDD, click the Transformation tab.
7. You can add derivation to data elements of the EDD.
   • Click Add to create derived data elements.
   • To edit the derived data element, click Edit. The Expression window is displayed.
   • The expression can be specified using the data elements defined in the Data tab and functions.
   • To delete the derived data element, click Delete.
8. Click the Transformation tab and select the Transformation Type.
   • Select Aggregation and click Edit to view Expression window.
   • Specify the Group by clause and having expression, if applicable.
   • Define Derived Data Elements for the field to be aggregated under the previous tab.
9. Click Save.