In a short few years, data warehouse has become an indispensable and integral part of all business activities. To ensure that it remains effective and keeps serving its primary objectives,…
Metadata Repositories: The Managers of a Data Warehouse
Metadata helps with data management and serves as a descriptor for an object that holds some data or information. In data warehouses, it is collectively organized in a catalog called…
The 3 Stages of Data Cleansing to Ensure Data Accuracy in Your Data Warehouse
Are you embarking on a cleansing journey for your data warehouse initiative? In this article, we will cover the 3 phases of data cleansing to help you define a process…
Data Warehouse Cleansing - Eliminate Bad Data in Your Data Warehouse
[…] analysis. This blog post is focused on the importance and challenges associated with ...
[…] when accessed. Different view levels can be offered to different tiers of users. More...
Which Data Integration Approach is Right for You?
An enterprise uses an average of 928 applications, along with many other on-premise systems. This means that you can have about a thousand source systems from different vendors, each storing…
[…] Data virtualization serves as an alternative to ETL and traditional data warehousing ...
An Overview of Logical Data Warehousing
Popularized by Gartner IT analyst Mark Beyer in 2011, the term “logical data warehousing” is defined as an architectural layer that combines the strength of a physical data warehouse with…
[…] from different source systems. That’s why data virtualization layer is also referre...
[…] is not possible without significant data conversion and transformation, triggering th...
What is Data Virtualization?
At its core, data virtualization falls within the domain of data integration. But unlike traditional data integration where Extract-Transform-Load (ETL) processes are used to physically move copies of data from…
[…] with the help of emerging data warehousing techniques like data warehouse automation ...
[…] data virtualization, the data rests at one place and is not moved or replicated to an...