Physical Schema = Logical Schema + Context
For Example: Consider an Organization A whose Branches are A1,A2 and A3.
Consider the Structure of A1,A2 and A3 Schema's are same but located in different Servers. By the EOD all the data stored in A1,A2 and A3 to be stored in A.
For above scenario, developer develops one mapping with one logical Schema , 3 Physical Schema (A1,A2 and A3)and 3 Context (A1_CTX,A2_CTX and A3_CTX) . While executing the mapping if he selects A1_CTX it loads to A1. (i.e., Logical_schema+A1_CTX = A1... ) . That means we can reuse same code to pick data from different schema's.
Posted Date:- 2021-10-08 03:49:27
What is the Master Repository?
How to write the procedures in ODI?
How to remove the duplicate in ODI?
How to write the subqueries in ODI?
What are the load plans and types of load plans?
How will you handle data quality in ODI?
How will you bring in files from remote locations?
How will you bring in the different source data into ODI?
Explain what is ODI? why is it different from the other ETL tools?
How to reverse engineer views(how to load the data from views)?
How to load the data with one flat file and one RDBMS table using joins?
How to implement data validations?
How to remove the duplicate in ODI?
How to write the sub-queries in ODI?
What are load plans and types of load plans?
Where does ODI sit with my existing OWB implementation(s)?
Does ODI support web services?
Where can I get more information on ODI?
Does my ODI infrastructure require an Oracle database?
What is Load Plan and different types of Load Plans?
How do ‘Contexts’ work in ODI?
What is Simulation option at interface?
What is Context and it's purpose?
What is an Agent and different types of Agents?
What is significant difference between Physical Schema and Logical Schema?
What is meant by OLAP and OLTP?
What is Repository and Types of Repositories?
What is the difference between ETL and ELT?
What systems can ODI extract and load data into?
What is Oracle Data Integration Suite?