Data Warehouse Architecture Archives | Page 2 of 4 | Data Warehouse Information Center

Cloud Technology Making its Way in Data Warehouse Architecture

A data warehouse creates a centralized source of data which facilitates business intelligence, strategy, and decision-making. Thus, having an effective and efficient data warehousing solution is extremely important for any…

Posted byAelia Haider
December 21, 2018
3 minute read
2

4 Data Warehouse Optimization Mistakes to Avoid | Data Warehouse Info Center
[…] forced enterprises to rethink their data warehousing strategy. Among the emerging alt...
September 11, 2019
Data Warehouse Governance: Best Practices | Data Warehouse Information Center
[…] project. The purpose of having business people in the governance body is to ensure th...
March 19, 2019

SQL Vs. NoSQL: Which data warehouse Approach is Better?

Technical Resources

SQL Vs. NoSQL: Which Database Approach is Better?

When it comes to database technology, there are two common categories: SQL and NoSQL or relational and non-relational database respectively. They are called SQL and NoSQL referring to whether they…

Posted byIrfan Ahmed
December 19, 2018
4 minute read
0

Technical Resources

Traditional vs. Cloud – Comparing the Shift in Data Warehouse Architecture

Data warehouse architecture is changing, and it has been changing for some time now. The traditional on-premise deployment model was succeeded by cloud deployment. However, cloud-based data warehouses are different…

Posted byNida Fatima
December 14, 2018
3 minute read
4

Iqbal Ahmed Alvi
Thank you....
March 27, 2020
kumari
Thanks for the informative blog...
March 20, 2020

Technical Resources DWAccelerator Blogs

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…

Posted byFahad Fareed
December 11, 2018
4 minute read
0

Technical Resources

Gauging Agility: Testing for Agile Data Warehouse Environment

In this era of data-driven decision making, data quality holds immense significance. Accurate data has been gauged to be a priority factor in customer experience enhancement and creating a business…

Posted byIqbal Ahmed Alvi
December 10, 2018
4 minute read
0

Technical Blogs

Decoding the Abstraction Layer in Data Warehousing

Before the Xbox and iPhone, prior to the first Facebook Like or Tweet, and well before the cloud and tablets, there was the data warehouse. For over 30 years, businesses…

Posted byIqbal Ahmed Alvi
November 28, 2018
3 minute read
1

Justin
Great post....
March 25, 2020

Technical Blogs

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…

Posted byTehreem Naeem
October 24, 2018
3 minute read
2

Data Warehouse Cleansing - Eliminate Bad Data in Your Data Warehouse
[…] analysis. This blog post is focused on the importance and challenges associated with ...
October 10, 2019
Decoding the Abstraction Layer in Data Warehousing | Data Warehouse Information Center
[…] when accessed. Different view levels can be offered to different tiers of users. More...
November 30, 2018

Technical Resources Technical Blogs

Deliver Changes to Your Data Warehouse in Real-Time with Change Data Capture (CDC)

Change Data Capture (CDC) is a technology that continuously scans source data systems for changes, identifies them, and delivers those changes to the data warehouse in real-time, so business intelligence…

Posted byIqbal Ahmed Alvi
October 1, 2018
3 minute read
0