Dylan's BI Study Notes

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

Disclaimer:

Opinions expressed in this blog are entirely my own and do not reflect the position of Incorta or my previous employer Oracle.
Social
Calendar

May 2024

S M T W T F S

1 2 3 4

5 6 7 8 9 10 11

12 13 14 15 16 17 18

19 20 21 22 23 24 25

26 27 28 29 30 31

« Feb
Categories
- AW
- BI
- BI Application
  - Customer Intelligence
  - Financial Intelligence
  - Human Resource Intelligence
  - Marketing Intelligence
  - Procurement Intelligence
  - Project Intelligence
  - Sales Intelligence
  - Service Intelligence
  - Supply Chain Intelligence
- BI Links
- BI Work
- Big Data
- Business Intelligence
- CDH
- CDI
- Common Dimension
- Customer Data Integration
- DAC
- Data Lake
- Data Science
- Data Warehouse
- DBI
- EBS
- EDW
- Enrichment
- EPM
- essbase
- ETL
- hyperion
- Incorta
- Infomatica
- Master Data Management
- MDM
- ML
- OBIA
- OBIEE
- ODI
- OLAP
- Oracle
- Oracle BI Suite EE
- Oracle Data Integrator
- OTBI
- OWB
- PeopleSoft
- SAP
- SCD
- Siebel Analytics
- Sunopsis
- UCM

Meta
- Register
- Log in

Subscribe
- Entries (RSS)
- Comments (RSS)

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