Saturday, 30 May 2020

BI Apps / Oracle Analytics Cloud (OAC) - Informatica vs ODI Terminologies





Informatica
ODI
 1
DAC
BI Application Configuration Manager
 2
Load plan has tasks
Load plan has steps
 3
Does not exists
Functional Setup Manager
 4

One master repository and many work repository for dev/test/prod

Master Repository - Security information including users, profiles,
 5
Mappings
Interfaces
 6
Workflow
Package
 7
Informatica integration server
ODI Run-Time Agent
 8

Model is a folder
 9

Datastore - table structure and columns
 10
Refresh date
Prune date - Used in full and incremental load w_etl_load_dates