Supplier Dimension to include Customers & Employees
Page 1 of 1
Supplier Dimension to include Customers & Employees
We are in the process of finalising Dimensions /Facts to be used in Datawarehouse.
Already finalised separate dimensions (eg Customer,Supplier,Employee) to handle requirements of Sales,Purchace and Human resourses.
During designing Accounts Payable Fact table ,the "Business requirement" requires payments made to Suppliers,Customers & Employee separately identified.
Now the question is
Whether to have three foreign keys in addition to other foreign keys in the Accounts Payable Fact Table
Or
Add Employees and Customers to be included in supplier master and attributes set for suppliers to be populated for customers/employees. Attributes relating only for sales related analysis and employee related analysis are not included in the new dimension.
In this case Accounts Payable Fact table will have only one Foreign Key pertaining to the entity receiving the payment.
Please advice as which is the best strategy and how
Already finalised separate dimensions (eg Customer,Supplier,Employee) to handle requirements of Sales,Purchace and Human resourses.
During designing Accounts Payable Fact table ,the "Business requirement" requires payments made to Suppliers,Customers & Employee separately identified.
Now the question is
Whether to have three foreign keys in addition to other foreign keys in the Accounts Payable Fact Table
Or
Add Employees and Customers to be included in supplier master and attributes set for suppliers to be populated for customers/employees. Attributes relating only for sales related analysis and employee related analysis are not included in the new dimension.
In this case Accounts Payable Fact table will have only one Foreign Key pertaining to the entity receiving the payment.
Please advice as which is the best strategy and how
gssunder- Posts : 1
Join date : 2011-01-31
Similar topics
» Customer and supplier at same time
» Dealing with System upgrades/supplier renumbering.
» Organizational hierarchy with employees and SCD
» Help in design about employees cost
» Design to calculate CHURN (movement of employees between business units)
» Dealing with System upgrades/supplier renumbering.
» Organizational hierarchy with employees and SCD
» Help in design about employees cost
» Design to calculate CHURN (movement of employees between business units)
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum