Recall the dimensional data model from earlier in this chapter, repeated here with slightly more detail, in Figure 9.10.
In a dimensional model, each table is assigned a Table Model type, which is distinguished by an icon displayed in the upper left corner of the entity or table box. You can further define a table in the Table Editor by assigning it a Table Type that displays at the bottom of the table (e.g. Fixed). The Table Type does not change how the data is handled but provides information to the reader about the data in the table. It is purely for documentation purposes.
Figure 9.10 Financial dimensional LDM
Account Balance is an example of a fact table (on a conceptual and logical data model ...