The following diagram shows the pattern to be used while developing the Oracle Data Integrator components for a custom dimension. It is similar to the out-of-the-box pattern with the user extension component excluded.

Create the table and a sequence in the database. The dimension table should have a surrogate primary key and a unique key which includes the data source indicator and a column from the source.