Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management


RKM is the ODI knowledge module used for reverse engineering the model.

Reverse-engineering is the process of creating or updating a model in ODI.

ODI can use JDBC to retrieve metadata.  The table and column definitions are those accessible from the JDBC.

You can also read the metadata from application metadata repository.  For example, Oracle E-Business Suite stores the table and column description in the Application Object Library (AOL) tables, which are the base to generate the eTRM (Technical reference manuals).

Writing a EBS KM allows us to get the information about the table and column definitions.

RKM allows you to write the custom reverse-engineering logic.




Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s