In this example, you create a data model to determine the structure of the data to be managed in the Reconciling client data campaign which allows data stewards to merge redundant client data coming from different systems.
Talend Data Stewardship has data model awareness which makes syntactic and semantic validation of data possible. Therefore, a campaign relies on a data model to ensure that the data matches the expected structure and format.
By defining the structure of data for this Merging campaign, you define the attributes in the data model and select their types out of a predefined standard or semantic types.
Before you begin
-
An administrator has created Talend Data Stewardship users and assigned them roles in Talend Administration Center. For further information, see Creating Data Stewardship users.
-
You have been assigned a campaign owner role in Talend Administration Center.
Procedure
-
Enter a name and a description for the new model in the
Name and Description fields
respectively.
Optional fields are marked as optional next to their names
-
In the Attributes section, define the columns you want
to have in the data model as the following:
-
From the attribute type list, select the type of the column.
Standard and semantic types are integrated in Talend Data Stewardship by default
- For standard types, additional fields are displayed or hidden according to the type you select. These fields are optional and they enable you to define some constraints on the attribute you define such as defining a minimum and/or maximum length or defining a pattern against which to validate the attribute.
- For semantic types, you can use Talend Dictionary Service to manage the semantic types. However, the availability of this service depends on the license you have.
-
From the attribute type list, select the type of the column.