Creating a Project
Login to Oracle Data Integrator Studio to create a new project to maintain all custom mappings, procedures, and packages.
The project should include the following folder structure to organize objects:
Facts: To organize all fact mappings.
Dimensions: To organize all dimension mappings.
Replication: To organize all replication view mappings.
Materialized Views: To organize all materialized view mappings.
Create these folders for each product. Avoid cross referencing across different folders.
For example: A mapping under the Dimensions folder should not refer to a mapping in the Replication folder.