USB flash drives are ideal storage devices when we need to back up files and transfer data across different platforms. Even though a flash drive weighs less than 30 grams, …
Read More »Data Warehouse
DATA WAREHOUSE – ODS (OPERATIONAL DATA STORE)
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 »Mapping ile Tablo Aktarılması 2 – ODI Dersleri 6
Merhaba arkadaşlar, bu gün ki makalemizde mapping işlemlerine devam edeceğiz. Okumadıysanız öncelikle mappingin logical tanımlamalarını gerçekleştirdiğimiz makalemi okumanızı tavsiye ederim. Makaleye buradan erişebilirsiniz. Bu gün ki makalemizde Pyhsical sekmesinde …
Read More »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 »Introduction of DATA WAREHOUSE-What is DATA?
What is Data? This word, which has a very high popularity, is actually called data, each letter number or date information entered in the computers we use as technology and …
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 »