This is a big chapter, so prepare a mug of your favorite coffee and make sure that you are comfortable and ready to move on.
In the previous chapter, we had an overview of the creation process of the Universe from start to end. In this chapter, we will focus on the Data Foundation layer, which is the core resource for any Universe. However, before that, we will talk about data connection, as it is the first Universe resource that we need to create. After that, we will learn how to use different functions and features provided by the Data Foundation layer.
In this chapter, we will cover the following topics:
Working with data connections and learning the difference between the relational and OLAP connections
Learning the difference between single-source and multisource Data Foundation
Learning the difference between the physical database table, view, alias table, and derived table
Populating
NorthWindData Foundation layer with tables, views, alias...