fact table
2 posters
Page 1 of 1
fact table
I am working on an HR dimensional model and have a SALARY_FACT and COST_DISTRIBUTION_FACT. Can i combine these facts? Cost distribution is how and from wher the payments are made, (dimensions include; fund, cost center, order, functional area)
Salary_fact dimensions include job_posting, organization, Date
Both the facts have Person_employee_dim in common. I also want to know if i can separate Person_employee_dim and create two different dimensions, one person, one employee. If yes which one is a better option. Person dimension will include general person information, like name, address, ethinicity, etc. Where as Employee will include information related to that particular employee and his/her employement with the organization.
I appreciate the help.
thank you.
Salary_fact dimensions include job_posting, organization, Date
Both the facts have Person_employee_dim in common. I also want to know if i can separate Person_employee_dim and create two different dimensions, one person, one employee. If yes which one is a better option. Person dimension will include general person information, like name, address, ethinicity, etc. Where as Employee will include information related to that particular employee and his/her employement with the organization.
I appreciate the help.
thank you.
varun- Posts : 5
Join date : 2011-09-28
Re: fact table
These sound like different fact tables to me. The primary deciding factor is not common dimensions but grain and type of fact table. If the grain is the same and the fact table type (transaction, snapshot, accumulating snapshot) is the same, then add metrics to your hearts content.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» 'Routing' the grain of the fact table to multpile members of multiple dimensions causes the fact table to 'explode'
» Integrating new fact table which has one to many relationship with the main fact table in existing star schema
» How to create fact table with measures derived from comparing two fact table rows
» Healthcare Hospital Stay fact table - transaction fact table - a row for In and a row for Out?
» Design a snapshot Fact table in data mart from compliance-enable fact table in enterprise data warehouse
» Integrating new fact table which has one to many relationship with the main fact table in existing star schema
» How to create fact table with measures derived from comparing two fact table rows
» Healthcare Hospital Stay fact table - transaction fact table - a row for In and a row for Out?
» Design a snapshot Fact table in data mart from compliance-enable fact table in enterprise data warehouse
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum