Modifying an ETL Load Plan (ODI Only)
You may also want to modify an existing ETL to meet your reporting requirements.
See Also:
- Oracle ® Fusion Middleware Developer's Guide for Oracle Data Integrator 11g/12c
To modify an ETL Load Plan without any changes to the associated tables or columns, perform the following tasks:
- Identify the Load Plan that needs to be modified in the repository.
- Identify the Interface/Mapping or Package in the Load Plan that you intend to modify.
- Open and modify the ETLs (Interface/Mapping/Procedure) in ODI Studio under the Project ArgusAnalytics111.
- Test and save the changes in ODI Studio.
- Verify that the changes made have been applied successfully.
- Regenerate the associated scenario with the Interface/Mapping/Procedure.
To modify one or more tables or columns without any changes to the associated ETL programs (typically to widen a column):
- Change the table/view properties, as required.
- Save the Interface/Mapping and regenerate the associated scenario in ODI Studio.
Parent topic: Extract Transform Load Programs