DIH provides the following benefits:
· Provides a level of abstraction and insulates upstream ETL processes from staging model changes.
· Supports Big Data.
· Provides a simplified mapping screen for loading data into OFSAA staging/result through an abstract layer.
· Removes ETL technicalities by prepackaging and predefining ODI parameters based on different use cases.
· Supports Download Specification which is a system managed meta object for upstream data mapping.
· Process/execution optimization for OFSAA data and known use cases. For example, in a direct one-to-one mapping, there will not be any hopping.
· Hosts pre-defined integration with Oracle Products that play the role of data providers to Analytical Applications.
· Helps in getting lineage directly from source data to staging till results.