LKM(used to extract data from heterogeneous source systems (files, middleware, databases, etc.) to a staging area).
IKM(used to integrate (load) data from staging to target tables)
RKM(used to perform a customized reverse-engineering of data models for a specific technology. It extracts metadata from a metadata provider to ODI repository. These are used in data models.)
JKM(used to create a journal of data modifications (insert, update and delete) of the source databases to keep track of changes. These are used in data models and used for Changed Data Capture.)
CKM( used to check data consistency i.e. constraints on the sources and targets are not violated. These are used in the data model’s static checks and interface flow checks. Static check refers to constraints or rules defined in the data model to verify the integrity of source or application data.
Flow check refers to declarative rules defined in interfaces to verify an application’s incoming data before loading into target tables.)
Posted Date:- 2021-10-08 05:02:35
How to load valid records into one table and invalid records into another table?
What are different ways to promoting code ?
How promote code from one environment another environment?
What is meant by load balancing and how to do setup for it?
What is sequence and different types of Sequence available in ODI?
Can we reverse engineer Flat Files?
Different types of Reverse Engineering?
What are the prime responsibilities of the Data Integration Administrator?
What is a procedure and how to write the procedures in ODI?
What systems can ODI extract and load data into?
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 write the sub-queries in ODI?
Does ODI support web services?
Explain step-by-step procedure to enable Journalization?
How to pass a variable more than one values?
What is Journalization and why we are using it in ODI?
What do you mean by "moving data" ?
How to tune a mapping in ODI ?
What are the types of data quality control?
What is SKM and when we will use this SKM?
Explain some differences between ODI 10g and ODI 11g?
What are the types of Knowledge Modules?
Can I create more than one Master Repository in ODI?
how to prevent overwrite existing data in table
Is it possible to place a variable as a parameter in an API Reference?
I'd like to ask if it possible to use a stored procedure (maybe in cursor) as a data source?
We have an options recyle_errors on target table Flow tab. how exactly it works?