Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

employment fact table

2 posters

Go down

employment fact table Empty employment fact table

Post  tim_goodsell Wed Dec 07, 2011 10:10 pm

Hi

I have the following dimensions

Member and Member Account, the dimensions are linked via Member_Member_Account as a Member can have one or more Member Accounts

Each account is associated with employment (employer, salary, employment status, occupation etc) and I was thinking of having an employment fact table to track the employment history (i.e salary changes)

This fact table will

Member Account Key
Employer Key
Effective Date
Occupation Type Key
Salary
Working Status Key ( Employed Full/Part Time, Unemployed Ceased/Retired/Other)


Is the best way to go

Regards

Tim

tim_goodsell

Posts : 49
Join date : 2010-09-21

Back to top Go down

employment fact table Empty Snapshot is in order

Post  elmorejr Thu Dec 08, 2011 9:45 am

From the sound of your requirements, it seems a snapshot is in order. You will want to take a snapshot of your source data (weekly or monthly) and load your fact. Your fact definition is going in the right direction as well, with some small changes:

Fact Snapshot Date Key
Member Account Key
Employer Key
Effective Date
Working Status Key ( Employed Full/Part Time, Unemployed Ceased/Retired/Other)
Occupation Type Key
Employee Start Date Key
Employee End Date Key
Employee Retirement Date Key

Salary


elmorejr

Posts : 25
Join date : 2011-10-20
Location : Columbus, Ohio, United States of America, Earth, Sol

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum