Snapshot data is a copy of business data preserved at some point-in-time. In some cases we may not be able to recover older snapshot data from the current data sets because we need to preserve snapshots at regular (scheduled) intervals for historical analysis.
Tags: Data Warehousing, Financial Analytics, Oracle E-Business Suite, Prabu Varatharaju, Informatica, Business Intelligence, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog
A key component to any Business Intelligence (BI) Architecture is the Extract, Translate and Load (ETL) process. The ETL process is typically scheduled on a daily basis and is capable of data movement from legacy systems into a data warehouse. It is also used to facilitate the work of the database administrators who connect different branches of databases as well as integrate or change the existing databases.
Tags: Data Warehousing, Oracle, Informatica, Business Intelligence, Sridhar Kasthuri, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog
Knowledge Modules (KM), components of Oracle Data Integrator’s Open Connector Technology, are generic, highly specific and reusable code templates which defines the overall data integration process. Each Knowledge Module contains the knowledge required by ODI to perform a specific set of actions or tasks against a specific technology or set of technologies, such as connecting to this technology, extracting data from it, transforming the data, checking it, integrating it, etc.
Tags: Ashok Das, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog
The Oracle Data Integrator platform integrates into the broader Fusion Middleware platform and becomes a key component of this stack. Oracle Data Integrator provides it's run-time components as Java EE applications, enhanced to fully leverage the capabilities of the Oracle WebLogic Application Server. Oracle Data Integrator components include the FMW exclusive features for Enterprise-Scale Deployments, high availability, scalability, and hardened security.
Tags: Shiva Molabanti, Oracle, Tutorial, Oracle BI, Oracle BI Applications, Oracle Data Integrator (ODI), Blog
The most common question faced by any ETL developer or a Data Warehouse project implementer is always related to performance. Whatever the tool may be, and however fast the job may be running, the end user will always desire something which is a little faster and quicker.
Tags: Data Warehousing, Training, Sharath Venkataranga, Business Intelligence, Tutorial, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog
The new release of the Oracle BI Applications (11.1.1.7.1) now leverages Oracle Data Integrator (ODI). This huge development means that ODI can alternatively be utilized as the primary data integration tool over Informatica. ODI and its Extract-Load-Transform functionality could provide customers a setup that delivers increased performance and reduced data integration costs.
Tags: Student Information Analytics, Webinar, JD Edwards, OBIEE, Vikas Agrawal, DAC, Oracle, Informatica, Business Intelligence, Video, Jeremiah Johnson, Events, Oracle BI, Oracle BI Applications, Exalytics, Examining OBIA 11g, Oracle Data Integrator (ODI), Hari Cherukupally, GoldenGate, Indirect Spend Planning, Blog
A Load Plan is an executable object in Oracle Data Integrator that can contain a hierarchy of steps that can be executed conditionally, in parallel or in series. Procedures, interfaces, packages, variables, and can be added to Load Plans for executions in the form of scenarios in a Load Plan.
Tags: Data Warehousing, Varun Reddy, Oracle, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog
As part of KPI's web series on Examining Oracle BI Applications 11g, this short video provides a brief overview of the new release of the Oracle BI Applications. Areas of examination for this session include:
Tags: Student Information Analytics, OBIEE, Financial Analytics, Peoplesoft Campus Solutions, Ramesh Ponganti, Project Analytics, Rushendra Prasad, Jeremy Simmons, Srinivasan T, Sharath V, Vlad Valeyev, Prabu Varathaju, Informatica, Video, Myles Gilsenan, Jeremiah Johnson, HR Analytics, Oracle BI Applications, Procurement & Spend Analytics, Examining OBIA 11g, John Whitaker, Oracle Data Integrator (ODI), Fixed Asset Analytics, Indirect Spend Planning, Oracle GoldenGate, Supply Chain and Order Management, Blog
Tags: Keith Mascarenhas, Oracle, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog
Oracle Data Integrator, or ODI, provides a new declarative design approach to defining data transformation and integration processes based on a unique Extract-Load-Transform (ELT) architecture. The declarative design approach separates the declarative rules from the implementation details. ODI architecture eliminates the need for a standalone ETL (Extract-Transform-Load) server and proprietary engine while leveraging the inherent power of RDBMS engines.
Tags: Data Warehousing, Training, Varun Reddy, Oracle, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog
