This lesson develops Projects, Models, Mappings, and Knowledge Modules within Oracle Data Integrator 12c: Integration and Administration Ed 3.
The work is anchored to a data engineering team delivering governed batch and near-real-time integrations across databases, files, and analytic platforms, so each decision is connected to a measurable operational result and an accountable owner.
The instructor traces projects, folders, variables, sequences, packages, and reusable procedures, then connects it to models, datastores, reverse engineering, keys, constraints, and data quality. The demonstration captures the exact configuration, transaction, command, query, log, or screen evidence needed to prove intended behavior and the applicable control boundary.
Learners execute a guided lab focused on models, datastores, reverse engineering, keys, constraints, and data quality and logical mappings, components, expressions, joins, sets, and execution units. The exercise introduces a realistic exception related to LKM, IKM, CKM, RKM choices, options, generated code, and mapping troubleshooting and requires a reversible correction supported by before-and-after evidence.
Acceptance requires accurate handling of logical mappings, components, expressions, joins, sets, and execution units, traceable proof for projects, folders, variables, sequences, packages, and reusable procedures, and a repeatable recovery path for LKM, IKM, CKM, RKM choices, options, generated code, and mapping troubleshooting. Results must be understandable to both implementers and operational support teams.
Learners compare symptoms, logs, state, dependencies, and recent changes when LKM, IKM, CKM, RKM choices, options, generated code, and mapping troubleshooting occurs. The final diagnosis must separate the immediate fix from the preventive control.
The completed output is a tested projects, models, mappings, and knowledge modules implementation or analysis, with validation evidence, troubleshooting notes, rollback guidance, and a concise operational handover.