Tag: Index

 

 

 

 

 

 

 

 

 

 

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)

 

Indexes are defined as constraints on the Model view in ODI Studio. To make a field unique follow one of the two alternatives listed below.

 

PRIMARY KEY

 

Define the Index as a Primary Key constraint object on the Models area within the design view

 

Add the unique columns on the Columns tab

 

 

In the Control tab make sure the constraint is active and marked to be defined in the database for both flow and static control checkboxes

 

 

 

 

Review that the correct settings are configured in the Flexfields tab

 

ALTERNATE KEY

 

Define the constraint object for your table as an alternate key in the ODI models area

 

Add the unique columns on the Columns tab

 

In the Control tab make sure the constraint is active and marked to be defined in the database for both flow and static control checkboxes

 

Review that the correct settings are configured in the Flexfields tab