Metadata Model Components
The metadata model contains components that represent the metadata of the data source.
The metadata model consists of the following components:
- Flat Record
- A flat record represents a structure that contains columns, unique keys, and primary keys. The structure of a flat record is similar to a database table that contains columns and keys.
A flat record contains attributes that store the following information:
- Name of the native metadata object
- Type of native metadata object
- Related records for the flat record
- Primary key for the flat record
- Unique keys for the flat record
- Indexes for the flat record
- Any additional record attributes specific to the data source
- A field is a data structure for a single unit of data in a data source.
A field contains attributes that store the following information:
- Name of the field
- Default value of the field
- Precision of the field
- Scale of the field
- Boolean value that indicates whether the field can contain a null value
- Any additional field attributes specific to the data source
- Constraints represent the primary key and unique keys for a flat record.
The primary key and unique key contain attributes that store the following information:
- Name of the key
- Native name of the key defined in the native metadata
- List of fields that form the key
- Index represents a native index that orders the flat records or uniquely identifies a row in the flat record.
An index contains attributes that store the following information:
- Name of the index
- Native name of the index
- Boolean value that indicates whether the index is unique
- List of index fields
- Index order to retrieve the data
The Informatica Connector Toolkit internally uses the metadata model components to represent the data source metadata and persists the metadata in the Model repository.