Dylan's BI Study Notes

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

Getting Start with ODI – Create a repository

To create an ODI repository, you can use File -> New and Select “Master repository wizard”.

It creates the database tables in the database you specified and import some seed data to the database.

ODI stores the DDL script in the local directory and store the data in the XML files.  By running the wizard, it runs these scripts.

This approach is very similar to DAC.