dimension table of company (including company code, company name, etc.
data warehouse, OLAP engine and rules engine, of which the data warehouse mainly contains the fact tables and dimension tables for storing various data information; OLAP engine provides methods and effective ways for operating and realizing the multidimensional data of data warehouse and provides support and guarantee for other parts of the system to efficiently utilize the data in data warehouse; and rules engine mainly provides the mechanism for users to manage and control the data warehouse.
In this scenario, the planning fact table contains five columns with IDs from the dimension tables for organization, time dimension, location, operation and clothe of type.
Key columns are fact table columns that have corresponding dimension tables.
data warehouse) directly, a snowflake schema will require the user to link the dimension tables together.
Once you selected the suitable database scheme and compiled fact and dimension tables in the form of an OLAP cube; you can start exploring the multidimensional data (Lachev, 2005).
This new lookup transformation caches dimension tables
in memory and applies advanced indexes to those tables to speed lookups of commonly referenced dimension data, such as product descriptions or customer names.
This is especially suited for enterprises with customer or product dimension tables
that contain millions of rows of data.