To define a new External Data Descriptor (EDD) from the DIH
Designer window, follow these steps:
Navigate to the Data Foundation Cloud Services home page, and then click
EDD.
The Data Ingestion Summary page is
displayed.
On the Data Ingestion Summary page, click
Add.
This will open the New tab.
Enter the name and description for the data descriptor, and then
select Datastore from the drop-down list. Select the data
source (example: FOUNDATION_DATA_STORE). The values in Defining an
External Data Store example are used. The description will be automatically
populated.
Click Save as Draft or click
Save.
Enter the required values in the fields.
If data needs to be reconciled post-loading, click the Control
tab. Currently, only the Number of Records controls is available in
the version.
To transform the EDD, click the Transformation
tab.
You can add derivation to data elements of the EDD.
Click Add to create derived data
elements.
To edit the derived data elements, click
Edit. This will open the
Expression window, where you can specify the
expression using data elements defined in the Data
tab and functions.
To delete the derived data element, click
Delete.
Click the Transformation tab and select the
Transformation Type.
Select Aggregation and click
Edit to view Expression
window.
In the 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.