Chapter 5. Working with Databases
Databases and database systems hold the vast majority of data processed by ODI around the world, so it's appropriate that we start our Purchase Order example by performing some basic work using databases.
Our overall example scenario involves uploading information concerning Purchase Order processing into a data mart and we'll begin by moving data from a customer data system's database into our data mart. To do this we'll be performing the following tasks:
- Take a quick overview of the physical layout of our source and target systems and the requirements for our first data integration task
- Configure data servers, Physical Schemas, and Logical Schemas for our target and source systems and link them to a Context using ...
Get Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
