Oracle Data Integrator: Types of Repositories

There are two types of repositories in Oracle Data Integrator:

Master Repository:

This is a data structure, containing information on the topology of the company's IT resources, on security and on version management of projects and data models. This repository is stored on a relational database accessible in client/server mode from the different Oracle Data Integrator modules. 

In general, you need only one master repository. However, it may be necessary to create several master repositories in one of the following cases: 

• Project construction over several sites not linked by a high-speed network (off-site development, for example).
• Necessity to clearly separate the interface's operating environments (development, test, production), including on the database containing the master repository. This may be the case if these environments are on several sites.

Work Repository:

This is a data structure containing information on data models, projects, and their use. This repository is stored on a relational database accessible in client/server mode from the different Oracle Data Integrator modules. Several work repositories can be created with several master repositories if necessary.

However, a work repository can be linked with only one master repository for version management purposes.

Note:

The standard method for creating repositories is using Repository Creation Utility (RCU). RCU automatically manages storage space as well as repository creation. However, if you want to create the repositories manually, it is possible to manually create and configure the repositories.

References: https://docs.oracle.com