STEPS FOR CREATING A MAPPING /INTERFACE IN ODI
STEPS FOR CREATING A DATABASE TO DATABASE MAPPING /INTERFACE IN ODI Create a master schema and work schema in database Create a master repository and work repository along with login Create Models and data stores for source and target Create a Project Import Knowledge modules Create a mapping PRE-REQUISITES: · A Database for configuring ODI repositories should be installed and running ,which may be one of the following Oracle IBM DB2 for iSeries (AS/400) IBM DB2 UDB PostgreSQL Sybase Microsoft SQL Server · ODI software (Downloads available in http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html ) should be installed and running . t The below mentioned steps for creating an interface in ODI is for Database to Database mapping. CREATING MASTER SCHEMA AND WORK SCHEMA IN ODI: · The first step is to create master and work schemas in the database (databases which ar