HOW TO INSTALL THE ODI PARTITION EXCHANGE REPOSITORY DEMO:

1. This ODI repository was created with ODI 12.1.3

2. In your Oracle database, login as sys or system, and create the following three schemas with default db roles "RESOURCE", and "CONNECT":

	a. MY_STG_AREA 
	b. MY_WAREHOUSE
	c. MY_ODI_WORK

3. Use the Oracle Fusion Middleware RCU utility to create a new ODI repository.  

4. In the ODI studio, select to import the master repository.  Perform the import in "Synonym Mode INSERT".  Use the following zip file:

	ODI_1213_PARTITION_EXCHANGE_MASTER_REPOSITORY.ZIP

5. In the ODI studio, select to import the work repository.  Perform the import in "Synonym Mode INSERT".  Use the following zip file:

	ODI_1213_PARTITION_EXCHANGE_WORK_REPOSITORY.ZIP

6. Go to ODI Topology, Physical Architecture, Oracle technology, and open the Warehouse data server.  Modify the JDBC connection and user password.  Test the connections.

7. Run script MY_STG_AREA.SQL in order to create and populate the staging tables.

	Example:  SQL> @MY_STG_AREA.SQL

8. Run script MY_WAREHOUSE.SQL in order to create and populate the warehouse tables.

	Example:  SQL> @MY_WAREHOUSE.SQL

9. Run script MY_ODI_WORK.SQL in order to grant privileges to the ODI work schema.

	Example:  SQL> @MY_ODI_WORK.SQL

10. Run script POPULATE_ORDERS.SQL  to populate the Orders table.

	Example:  SQL> @POPULATE_ORDERS.SQL

	NOTE: Use the max_rows variable to determine how many rows will be populated in the Orders table. Default is max_rows = 1000 (2,400,000 rows for 12 partitions).  
	NOTE: It takes about 5 minutes to populate 2,400,000 rows.

11. Once data is populated into the Orders table, open your ODI repository.

12. Go to the ODI Topology Manager, and open the Physical Architecture.  

13. Locate the Oracle technology and open the Data Server called Warehouse.  Change the JDBC connection and user password information for Warehouse.  Test your connection and save your changes.

14. Return to the ODI Designer, and read the description of the ODI project for information on how to use the demo before running any of the packages and mappings.

15. Run the following ODI package first to get familiar with how Oracle Partition Exchange works:

	Facts --> 01 - Initial Load Examples --> IKM Oracle Partition Exchange Load --> Configuration #1 - IKM Oracle Partition Exchange Load - Asynchronous - No Flow Control - Without Validation

16. Run any other ODI packages.

17. Review the ODI Operator logs to see how each of the packages performed and compared with each other.

18. For details on how to use Oracle Partition Exchange with Oracle Data Integrator, please visit the A-Team Web Site at:  http://www.ateam-oracle.com/data-integration/di-odi/

	
	Using Oracle Partition Exchange with Oracle Data Integrator (ODI): http://www.ateam-oracle.com/using-oracle-partition-exchange-with-oracle-data-integrator-odi/
	Configuring Oracle Data Integrator (ODI) with Oracle Partition Exchange: http://www.ateam-oracle.com/configuring-oracle-data-integrator-odi-with-oracle-partition-exchange/


19. End.

