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
|
Provides insights from Oracle resources and personal experience. Opinions are my own