ODI - A Journey - DAY 1

REPOSITORY

1. WORK
2. MASTER

• Work is always attached to Master. one to one relation.
• Master to work is One to Many.

Agent --> Once the Job needs to be executed , this agent will go from the Designer to Scheduler by the agent , and agent will ask details of the job from the Repo ( get the META DATA ) and then give to the Operator.

STUDIO PANEL

1. Designer
2. Operator
3. Security
4. Topology

STUDIO

TOPOLOGY

Physical Architecture

1. How the Work Repository gets created at first ?
2. JDBC connection is made to connect the Master and Work Repo.
3. 40+ Technologies are used to get the Meta Data / Schema Eg. Oracle DB , File , etc
4. If I have Oracle DB , then in TOPOLOGY add the the DB - here always referred to DATASERVER.
5. For Eg., SOURCE & TARGET SCOTT --> This is the Table --> which as DATA --> connect in the DATARERVER in TOPOGOLY ( Physical Architecture )
6. Data Server always as replacement for Target or Source.
7. Once loaded , create a PHYSICAL SCHEMA.
8. In Physical Schema , what is the difference between Schema and Work Schema ? Is it like Individual Schema you are trying to connect is referred as SCHEMA ? where this is WORK SCHEMA stored ?
9. Data Server is nothing but YOU ARE SAYING , you have been connected to one ORACLE DB.
10. WORK TABLE PREFIX --> this will help to identify where it failed and we can check the error in DB by using the PREFIX.
11. Why $ is specified in those ?
12. New Physical Schema is created under the DATASERVER.

CONTEXT

Logical Architecture

1. Click ORACLE , it will show only to create LOGICAL SCHEMA.
2. MAP the Logical Schema with the Physical Schema which is created against the GLOBAL CONTEXT. This Physical Schema name is " Complete Name " give to the PHYSICAL, not the schema and work schema.
3. Below SS will show the connection of Physical & Logical Relation.

Therefor , hereafter LOGICAL schema will be referred in the DESIGNER tab. NO NEED TO TOUCH PHYSICAL SCHEMA.

Questions

1. whether all PROD , DEV & UAT will have only one Master Repo?
2. W1 To M1 But W1 To M2 is not possible.

Important Commands

1. select * from v$instance; --> This will give the DB version.