Table of Contents

Search

  1. Preface
  2. Introduction to the Informatica Connector Toolkit
  3. Installing and Upgrading the Informatica Connector Toolkit
  4. Building an Adapter
  5. Connection Attributes
  6. Type System
  7. Metadata Objects
  8. Partitioning Capability
  9. Run-time Behavior
  10. Adapter Example: Instagram
  11. Adapter Example: MySQL
  12. Adapter Example: YouTube
  13. Metadata Models
  14. ASO Model
  15. Adapter Project Migration
  16. Frequently Asked Questions

Informatica Connector Toolkit Developer Guide

Informatica Connector Toolkit Developer Guide

Metadata Model Components

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
Field
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
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
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.


Updated May 15, 2019


Explore Informatica Network