ODI & Oracle: Interview Questions and Concepts - 2

 

What is a Work Repository in ODI?

ODI Work Repository stores project-specific metadata. Types:
1. Development Work Repository – Full design and execution
2. Execution Work Repository – Execution only, no design capabilities

Where can we use variables in ODI?

Variables can be used in Mappings, Procedures, Packages, Scenarios, Load Plans, and Knowledge Modules. They help in dynamic filtering, parameter passing, and conditional execution.

Can we connect Physical Schema directly in mapping?

No, mappings connect through Logical Schema. Logical Schemas resolve to Physical Schemas using Contexts.

In CDC, how does ODI know that a new record is inserted?

ODI uses Journalizing via Change Data Capture (CDC). It tracks changes in a journal table (e.g., J$TABLENAME) using triggers or LogMiner, and uses IUD_FLAG to distinguish insert, update, delete.

We want to process only update data from source to target using incremental update

Use CDC with IUD_FLAG = 'U' to process updates only. Alternatively, filter records using LAST_UPDATED_DATE > #LAST_RUN_DATE and update the variable after each run.

Force Editionable View

FORCE EDITIONABLE VIEW allows you to create a view in Oracle even if underlying objects don’t exist yet. It's useful in Edition-Based Redefinition (EBR) environments.
Syntax: CREATE OR REPLACE FORCE EDITIONABLE VIEW view_name AS SELECT ... FROM ...;