For Jim to define the solution and the data architecture, he needs access to the database system. He approaches Jean Trenary for getting access to the data warehouse and gets the access.
Once Jim gets the access to the system, he starts exploring every table related to sales available in the warehouse. This helps him to understand the nature of the data stored in the table and how it is linked to other tables in the warehouse.
He lists the dimensions and fact tables in the data warehouse which he would need to cater to all the sales related requirements.
Dimension tables are as follows:
|
Table Name |
Description |
|
DimCustomer |
This table stores all customer related data. The customer data is captured only for the online channel. It stores the demographic information, like FirstName, MiddleName, LastName, Birthdate, and Gender. ... |
