Organization Dimension
In a relational data model, for normalization purposes, corporate office lookup, region lookup, branch lookup, and employee lookups are not merged as a single table. In a dimensional data modeling(star schema), these tables would be merged as a single table called ORGANIZATION DIMENSION for performance and slicing data.
This dimension helps us to find the products sold or serviced within the organization by the employees. In any industry, we can calculate the sales on region basis, branch basis and employee basis. Based on the performance, an organization can provide incentives to employees and subsidies to the branches to increase further sales.
Example of Organization Dimension: Figure 1.10
Corporate Lookup
| Corporate Code | Corporate Name | DateTimeStamp |
| CO | American Bank | 1/1/2005 11:23:31 AM |
Region Lookup
| Region Code | Region Name | DateTimeStamp |
| SE | South East | 1/1/2005 11:23:31 AM |
| MW | Mid West | 1/1/2005 11:23:31 AM |
Branch Lookup
| Branch Code | Branch Name | DateTimeStamp |
| FLTM | Florida-Tampa | 1/1/2005 11:23:31 AM |
| ILCH | Illinois-Chicago | 1/1/2005 11:23:31 AM |
Employee Lookup
| Employee Code | Employee Name | DateTimeStamp |
| E1 | Paul Young | 1/1/2005 11:23:31 AM |
| E2 | Chris Davis | 1/1/2005 11:23:31 AM |
Organization Dimension
| Organization Dimension Id | Corporate Name | Region Name | Branch Name | Employee Name | DateTime Stamp |
| 1 | American Bank | South East | Florida-Tampa | Paul Young | 1/1/2005 11:23:31 AM |
| 2 | American Bank | Mid West | Illinois-Chicago | Chris Davis | 1/1/2005 11:23:31 AM |
Time Dimension