The source systems, which we discussed in Chapter 5 – The Origin of Data, and which we will use to access data, store the data in a certain data model. Except in the case of a flat table, where we have only a single table to import, in most situations we will incorporate a number of tables. These tables have a certain relationship to each other, which is described by a data model.
We will consider the possible data models that are frequently encountered, namely the flat table, the relational model, and the star schema. We will go into ...