Posted On: Feb 22, 2018
The measurements of business processes are present in the fact table. The foreign keys for the dimension tables are also contained by the facts table. For instance, in the “tea production” business, the “average tea production tea by one machine” or “weekly tea production” would be considered as a measurement of the business process. Whereas textual attributes of measurements stored in the facts tables are included in the dimensional table. A dimensional table is a cumulation of categories, hierarchies, and logic.
Never Miss an Articles from us.
People associated with IT and Computers get the concept easily. Business official understands MDM but not up to the level of former because businessmen are more interested in only knowing what benefit...