Double-click the title bar of the source definition for the EMPLOYEES table to open the EMPLOYEES source definition.
The
Edit Tables
dialog box appears and displays all the properties of this source definition. The
Table
tab shows the name of the table, owner name, and the database type. You can add a comment in the Description section. Business name is empty.
Click the
Columns
tab.
The
Columns
tab displays the column descriptions for the source table.
The source definition must match the structure of the source table. Therefore, you must not modify source column definitions after you import them.
The following image shows the
Columns
tab for EMPLOYEES source definition:
Click the
Metadata Extensions
tab.
Metadata extensions allow you to extend the metadata stored in the repository by associating information with individual repository objects. For example, you can store contact information, such as name or email address, with the sources you create.
In this lesson, you create user-defined metadata extensions that define the date you created the source definition and the name of the person who created the source definition.
Click the
Add Metadata Extension
button.
Name the row SourceCreationDate and enter today’s date as the value.
Click the
Add Metadata Extension
button to add another metadata extension and name it SourceCreator.
Enter your first name as the value in the SourceCreator row.