Dylan's BI Study Notes

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

Data Integration

General

Oracle BI Apps for Oracle eBusiness Suite Adapter

Use Last Update Date for Change Capture

Lookup the Data Warehouse FK with SCD enabled

ODI

Getting Start with ODI

1. Creating a new master repository

2. Creating a work repository

 

ODI – Architecture

 

ODI SDK

ODI SDK – Create Project

ODI SDK – Create Folder

ODI SDK – Create Subfolder

ODI SDK – Create Shortcut to Interface

ODI SDK – Create Variable

ODI SDK – Update Variable

ODI SDK – List Project

ODI SDK – List Folder

Advertisements