The Manage Model window
The Manage Model window is split into two tabs: The Logical Model tab and the Physical Model tab. The Logical Model tab shows the entities and attributes as they appear in the model whereas the Physical Model tab provides a preview of the actual tables (and columns) that will be created in the data warehouse. So, for example, although the Categories table appears as a single entity in the Logical Model tab, it will appear as two tables (TDWH_Categories_HUB and TDWH_Categories_S01) in the Physical Model tab. The reason for this is because the logical Categories entity contains both Type 1 and Type 2 attributes. Type 1 attributes will be created as columns in the HUB table while Type 2 attributes will be created as columns in the Satellite table (S01). For more information on Type 1 and Type 2 attributes, see History.
All editing tasks are performed in the Logical Model tab, except for the following tasks which are performed in the Physical Model tab:
- Designate a Distribution Key Column (Amazon Redshift data warehouse only)
- Designate a Distribution Method (Microsoft Azure Synapse Analytics only)
For more information, see Defining Table Creation Modifiers.