Figure below illustrates the flow of data through the data warehouse ecosystem.

In addition to a data flow, the data warehouse ecosystem has a rich metadata flow as well as a number of metadata specific tools, as illustrated in figure below.