Work Repository FAQS

1. What is a Work Repository?

• A Work Repository is a data structure that contains information about data models, projects, and their usage. It is stored in a relational database and is accessible through Oracle Data Integrator (ODI) modules in client/server mode.

2. How many Work Repositories can I create?

• You can create multiple Work Repositories. Several Work Repositories can be created in conjunction with multiple Master Repositories if needed.

3. Can a Work Repository be linked to more than one Master Repository?

• No, a Work Repository can only be linked to one Master Repository for version management purposes. This ensures proper version control and organization.

4. How are repositories created in Oracle Data Integrator?

• The standard method for creating repositories is through the Repository Creation Utility (RCU), which automates the process, including storage space management and repository creation.

5. Can I create repositories manually?

• Yes, you can manually create and configure repositories. This can be done using ODI Studio if you prefer a customized setup rather than using the RCPU tool.

6. What is the advantage of using the Repository Creation Utility (RCU)?

• RCPU simplifies the repository creation process by automating the management of storage space and streamlining repository creation, making it more efficient.

7. Can I access a Work Repository remotely?

• Yes, Work Repositories are stored in relational databases and are accessible via client/server mode from various Oracle Data Integrator modules, allowing remote access.

8. What is the main difference between a Master Repository and a Work Repository?

• A Master Repository stores information about the topology, security, and version management of IT resources, while a Work Repository focuses on storing data models, projects, and their use within the integration process.