ODI 12C Developer A to Z Training

Explore how Oracle ODI repositories organize security, topology, designer, and operator components into master and work repositories, with execution vs development work repositories for operator and designer involvement.

Establish a database connection, create a master repository in Oracle Data Integrator, and set up a work repository while creating and granting privileges to master and work users.

Establish a connection to the master repository, create a development work repository, and set up an execution work repository in Oracle data integrator, including topology and security configurations.

Establish connections to source and target Oracle databases through the topology component, create users with privileges, define data servers, and configure physical and logical schemas within the production context.

Demonstrates creating a first ODI mapping: read data from a local directory, transform product names to uppercase, abbreviate country values, fill blanks, and load into the target table.

Discover how Oracle Data Integrator uses LKM and IKM knowledge modules, including reverse engineering, loading, integration, and data quality modules, to manage metadata, staging areas, and target tables.

Explore Oracle data integrator knowledge modules LKM and IKM Part-02 through data validation, staging area setup, and flow and static control to isolate duplicates and cleanse data.

Implement change data capture (CDC) in ODI 12c by setting up source and target models, importing the generalized knowledge module, starting the journal, and enabling generalized data only.

Demonstrates assembling customer and order data with ODI using union and set components, then applying inner and outer joins to populate the target customer table through a mapped data flow.

Use the ODI aggregate component to create an integrated policy that groups data by country and computes total order amounts and product counts.

Use a split component in ODI to divide customer data into two tables, Germany and France, by configuring a join, setting a split condition, and routing outputs to each target.

Explore the ODI lookup component, with two inputs and support for inner and left outer joins, plus data store creation, field mapping, and lookup conditions.

See how the private component in ODI 12c generates a pivot view by building source and target tables, mapping thoughts to courses, and aggregating marks for networking, Java, and C++.

Create a new mapping and use the unpivot component to transform source data into a target table, mapping student attributes and extracting course values like networking, Java, and C++.

Use ODI procedure to define and run multiple tasks in steps, including updating department salaries and inserting top five salaries, with options for multi-connection or single-connection.

Create and configure ODI variables to store values, manage history and security, and replace literals in mappings. Refresh variables from the database to propagate updates across mappings.

Create and manage database sequences in ODI, including standard, specific, and native sequences; set start, increment, and current value, then apply them in Salesforce to database mappings.

Process a json file using standard and specific sequences to generate incremental identifiers in a mapping, illustrating current value retrieval from the database for specific sequence.

Compare specific and standard sequences in mapping and in procedure, and observe how the agent processes data, causing different sequence increments for each row.

Learn to create reusable mappings in ODI with input and output signatures, define attributes like product id, name, country, city, sales, quantity, discount, and profit, and reuse in another mapping.

Lock components such as mappings and procedures to prevent edits, create and compare multiple versions of mappings, and restore a prior version to manage secure, auditable changes in ODI.

Explore scenarios in ODI 12C by generating, viewing, and executing mappings as executable scenarios; compare version 001 and 002, and learn how regenerating or creating new versions preserves changes.

Create and configure ODI package in Part-01 to execute ODI objects in a sequence, including mappings, procedures, packages, and sequences, using the tool box and FPP get and put steps.

Shows configuring ODI's audio file with a utility to copy or move files from a source to a backup directory, with timeout, polling, and handling for no files.

ODI 12C developer training shows how to consume a RESTful service by configuring data, physical, and logical schemas, testing connections, and packaging steps to transfer employee details to a server.

Learn to append multiple files into a single file with odi utilities, using file parts, headers, and mappings, then load the result into a target table.

Learn to configure the reedman utility to read mail, specify mail server credentials and attachments, then use the wait-for-table step to ensure target table creation and data loading in ODI.

Explore ODI package steps that trigger on data presence, using variables and filter conditions like age less than 30 on the employee table, plus sleep and wait to pause execution.

Configure change data capture with external tools like Golden Gate, specify logical schema and subscriber table, and manage parallel versus sequential steps using parent-child sessions.

Create and manage package variables, including set and refresh types, explain global versus project scope, use these variables in transformations and database-driven configurations with history.

Discover dimensional modeling for data warehouses, using denormalized dimensions and fact tables to reduce joins and boost query performance. Learn about dimension vs fact, keys, and metric calculations.

Explore star schema, snowflake schema, and galaxy schema in data warehousing, comparing their fact and dimension tables and normalization levels.

Design a dimensional model by identifying the business process, grain, and dimensions like month, territory, salesperson, and customer. Build fact tables for sales and revenue to reveal top performers.

Learn slowly changing dimensions in data warehouses, with type 1, type 2, and type 3 approaches for capturing evolving customer data and their history.

Explore how to implement a type 2 slowly changing dimension in ODI, including surrogate keys, sequence-generated identifiers, start and end timestamps, current status, and historical data management.

Learn to create master and work repositories with RCU, and understand how it differs from studio creation, including Stoebe infrastructure and fusion middleware components.

Configure a standalone agent by creating a master and work repository, selecting templates (standalone, Oracle agent, agent libraries, console, and Oracle Enterprise Manager), and starting the agent via command prompt.

Learn how to start a standalone agent by running the start command with the agent name and port 20910, and verify its status with a test.

Explore how to create and execute load plans with serial and parallel steps, scenarios, and mappings, including restart from failure, regenerating mappings, and conditional routing based on variables.