The topic of indexes in Oracle Data Integrator (ODI) is an easy one once you learn your way around in ODI studio. Indexes are defined under Design > Models > [your model] > [Table] > [Constraints]. They are independent of the column definitions for the most part although they do reference valid column definitions.
- The first step to create metadata for an index is to add a new constraint and name it:
- On the Columns tab define the list of columns to be indexed
- Ensure that the index is active and marked for creation on the database on the Control tab
- Review all additional options on the Flexfields tab, for some of the options such as Index Type you do need to manually type your selection.
After you have defined an index on metadata you need to run a new load for the index to be created on the database.
My Tools:
Oracle Business Intelligence Applications (OBIA) 11.1.1.7.0
Oracle Data Integrator 11g (ODI Studio, ODI Server, no clustering)