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.