1. What is ODI ?
Oracle Data Integrator is an ELT based tool used to lift, shift & massage of the data.
This is one of the tool provided by Oracle, for data transfers. This has got most grateful features among many. Ofcourse this is the only tool which does the data transfer in ELT mode.
Below are few ETL tools
Powercenter -> Informatica (ETL)
Oracle --------> ODI (ELT)
2. What are the tools available in ODI?
a. Designer --> used to design the models, interfaces, package, scenarios, variables etc for all design related activities
b. Topology -> for all connection related information
c. Security Manager -> for granting the respective privileges to the users and to maintain user related information.
d. Operator---> to view the execution output of each step of the package/ interface etc. This is the common tool to view all the outputs.
Designer & Operator ---> Work Repository
Topology & Security Manager --> Master repository
3. Types of ODI Repositorities?
Master repository & Work repository
Master for all connection related & security related information.
This is the primary schema to create, once we login to the Master repository we can create the work repository
4. What is physical data server?
In Topology, to define any connection, we need to choose the corresponding technology and under which we will have the data servers, data server is the details pertaining to the corresponding database connection details.
Under the dataserver we will need to create the data schema & work schema
5. What is logic connection?
It is the logical connection name to bind it in the code. It is advisable not to change the logic connection name however a physical connection to it can be changed at anytime through context.
6. What is context?
Context in simple terms is an 1 to 1 mapping detail provider. This sole contains the physical schemas & logical names, through context we can just mapp these 1 to 1 basis.
7. What is a model?
Model is a metadata of any datasource. To build any mapping, we create the connections first in logical & physical, mapp them using the context and import the structure & other db keys etc of the required tables which is called metadata into the ODI to proceed with the mappings design.
8. What is Project?
After creating model, to create a mapping, the first step is to create a project, under which we start creating the mappings.
9. what is an Interface?
Interface is an dataflow path, to choose from which source to which target the path and coloumn to column mapping is defined. The sources can be multiple however all the sources has to be joined mandatorily and the target is always one.
However in recent knowledges modules they have placed an alternate way to define multiple target destinations
10. What is knowledge module (KM)?
KM has series of steps to run the mapping. There are different types of KM's provided by Oracle which normally selected based on the technology & types of insertion. The KM's are normally written using the Jython code.
11. What are the types of KM's?
LKM --> Load knowledge module (to bring the data from Heterogeneous systems of source to Staging area)
IKM -> Integration Knowedge module (To load the data into target from staging area)
CKM -> Check Knowledge Module (Verify the data , based on technology there are different CKM's available)
JKM-> Journalised knowledge module (Used for Change Data Capture )
SKM -> Service Knowledge module (Used for generating code to consume webservices in metadata)
Oracle Data Integrator is an ELT based tool used to lift, shift & massage of the data.
This is one of the tool provided by Oracle, for data transfers. This has got most grateful features among many. Ofcourse this is the only tool which does the data transfer in ELT mode.
Below are few ETL tools
Powercenter -> Informatica (ETL)
Oracle --------> ODI (ELT)
2. What are the tools available in ODI?
a. Designer --> used to design the models, interfaces, package, scenarios, variables etc for all design related activities
b. Topology -> for all connection related information
c. Security Manager -> for granting the respective privileges to the users and to maintain user related information.
d. Operator---> to view the execution output of each step of the package/ interface etc. This is the common tool to view all the outputs.
Designer & Operator ---> Work Repository
Topology & Security Manager --> Master repository
3. Types of ODI Repositorities?
Master repository & Work repository
Master for all connection related & security related information.
This is the primary schema to create, once we login to the Master repository we can create the work repository
4. What is physical data server?
In Topology, to define any connection, we need to choose the corresponding technology and under which we will have the data servers, data server is the details pertaining to the corresponding database connection details.
Under the dataserver we will need to create the data schema & work schema
5. What is logic connection?
It is the logical connection name to bind it in the code. It is advisable not to change the logic connection name however a physical connection to it can be changed at anytime through context.
6. What is context?
Context in simple terms is an 1 to 1 mapping detail provider. This sole contains the physical schemas & logical names, through context we can just mapp these 1 to 1 basis.
7. What is a model?
Model is a metadata of any datasource. To build any mapping, we create the connections first in logical & physical, mapp them using the context and import the structure & other db keys etc of the required tables which is called metadata into the ODI to proceed with the mappings design.
8. What is Project?
After creating model, to create a mapping, the first step is to create a project, under which we start creating the mappings.
9. what is an Interface?
Interface is an dataflow path, to choose from which source to which target the path and coloumn to column mapping is defined. The sources can be multiple however all the sources has to be joined mandatorily and the target is always one.
However in recent knowledges modules they have placed an alternate way to define multiple target destinations
10. What is knowledge module (KM)?
KM has series of steps to run the mapping. There are different types of KM's provided by Oracle which normally selected based on the technology & types of insertion. The KM's are normally written using the Jython code.
11. What are the types of KM's?
LKM --> Load knowledge module (to bring the data from Heterogeneous systems of source to Staging area)
IKM -> Integration Knowedge module (To load the data into target from staging area)
CKM -> Check Knowledge Module (Verify the data , based on technology there are different CKM's available)
JKM-> Journalised knowledge module (Used for Change Data Capture )
SKM -> Service Knowledge module (Used for generating code to consume webservices in metadata)
No comments:
Post a Comment