IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
ODS (Operational Data Store) ODS (Operational Data Store) is the database where all the source tables you need are stored in the live database. It is often used for data …
Read More »DATA WAREHOUSE – ODS (OPERATIONAL DATA STORE)
Tag Archives: data warehouse
DATA WAREHOUSE – OLTP/OLAP
OLTP (On-line Transaction Processing) By the mid-1970s, online transaction processing (OLTP) made even faster access to data possible, opening whole new vistas for business and processing. Shortly after the advent …
Read More »DATA WAREHOUSE – CHANGE DATA CAPTURE (CDC)
CDC (Change Data Capture) It can be called the process of defining and capturing changes made in the database. It is also referred to as a design pattern to identify …
Read More »DATA WAREHOUSE – ETL/ELT
What is the ETL / ELT? ETL or ELT is not a software abbreviation. It is the most important and complex stage of the data warehouse. ETL (Extract, Transform, Load) …
Read More »Introduction of DATA WAREHOUSE-What is DATA WAREHOUSE?
What is the Data Warehouse? A data warehouse is a repository that can be made of questioning and analysis of related data. The data warehouse has been created in order …
Read More »Data Warehouse Architectures
Data Warehouse Architectures I would like to talk about the two most important models of the Data Warehouse architect. These models are Bill Inmon and Kimballs models. I will not …
Read More »What Is In-Memory?
Hi everyone, Today i try to explain Oracle Database 12c In-Memory. In-Memory is a very important subject for Database and DWH. Oracle DB to store data in row format at …
Read More »