You can create a reference table from a flat file, from a data source in the Model repository, and from a table in another database.

You can create a reference table from a profile column or a subset of the data in a profile column. You can also create a reference table from the column patterns that you choose from a profile.

When you create or update a reference table, you configure the properties on the table and the data columns that it contains.