This post was originally published on Pure Storage
To understand the way your data warehouse functions, a diagram displays the flow of data and every resource included in the process. A data warehouse diagram helps organizations make decisions when upgrades are needed or changes to infrastructure are necessary for expansions. They can also be used when planning the design of a new warehouse.
What Are the Components of a Data Warehouse?
A data warehouse has five main components. Each of these components is included in a diagram that you create. Some warehouses have multiple instances of each component, but at least one will be present when you create your diagram.
The five components are:
ETL Procedures
Data is extracted from its original source and loaded into a database housed in the warehouse. The Extract, Transform, and Load (ETL) process is a set of commands used to pull data from its source (e.g., files stored on a server) and transform data before it’s loaded into the database. For example, you might take a full name from a file and transform it to a first and last name. The two values are then loaded into first and last name columns in the database.
Metadata
At first glance, data might be
— Read the rest of this post, which was originally published on Pure Storage.
