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

Fact Table or Factless Table: Please Suggest

4 posters

Go down

Fact Table or Factless Table: Please Suggest Empty Fact Table or Factless Table: Please Suggest

Post  aseem.sb Mon Jul 12, 2010 5:19 am

Hello All,

I am new to DW and as a first assignment I am trying to create data mart for Employee Leaves.

I have created following dimensions tables:

1. DimEmployee
2. DimDate
3. DimLeaveType

And Fact Table:

1. FactEmployeeLeave

In fact table currently there is no measure available (fact less fact table).

Please tell me is above design in correct or do I need to introduce any measure in fact table, if yes what will be that measure.

Target requirement is:

1. Able to find which month employee have maximum leaves.
2. Which employee taking excess leaves and which taking less.
3. Employee Designation wise leave status.

Please suggest me on fact table.

Regards,

Asim

aseem.sb

Posts : 6
Join date : 2010-07-12

Back to top Go down

Fact Table or Factless Table: Please Suggest Empty Re: Fact Table or Factless Table: Please Suggest

Post  BoxesAndLines Mon Jul 12, 2010 9:44 am

Number of days?
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Fact Table or Factless Table: Please Suggest Empty Re: Fact Table or Factless Table: Please Suggest

Post  aseem.sb Mon Jul 12, 2010 9:48 am

Hello,

In my Fact table one record is one leave. So the Number of days will be always one.

Regards.

aseem.sb

Posts : 6
Join date : 2010-07-12

Back to top Go down

Fact Table or Factless Table: Please Suggest Empty Re: Fact Table or Factless Table: Please Suggest

Post  LAndrews Mon Jul 12, 2010 12:42 pm


You just answered your own question.

Fact being measured is "Days_on_Leave", value on each record = 1.




LAndrews

Posts : 132
Join date : 2010-05-13
Location : British Columbia, Canada

Back to top Go down

Fact Table or Factless Table: Please Suggest Empty Re: Fact Table or Factless Table: Please Suggest

Post  aseem.sb Mon Jul 12, 2010 12:57 pm

Hello,

As i can take leave count in fact table, further i would like to know in this
Case which approch is better.

To have fact or to have fact less table.

Please suggest me as per best practice as i am not able decide the best approch.

Regards

aseem.sb

Posts : 6
Join date : 2010-07-12

Back to top Go down

Fact Table or Factless Table: Please Suggest Empty Re: Fact Table or Factless Table: Please Suggest

Post  ngalemmo Mon Jul 12, 2010 1:04 pm

Flip a coin.

The one advantage of storing a count is that if, in the future, you allow recording a multi-day absence in a single row, you are covered.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Fact Table or Factless Table: Please Suggest Empty Re: Fact Table or Factless Table: Please Suggest

Post  aseem.sb Mon Jul 12, 2010 1:13 pm

Hi,
Thanks for suggestion.

Addtionaly just want to ask one more question. As u said if i recod multiday leave in fact table i need to have two column in fact table i.e. start day and end day (fk from dimdate).

Is this understanding correct?

Regards.

aseem.sb

Posts : 6
Join date : 2010-07-12

Back to top Go down

Fact Table or Factless Table: Please Suggest Empty Re: Fact Table or Factless Table: Please Suggest

Post  ngalemmo Mon Jul 12, 2010 1:46 pm

Not necessarily. If you record the start date and number of continuous days, an end date would be redundant. Having it may make some queries simpler, but not having it isn't a major problem.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Fact Table or Factless Table: Please Suggest Empty Re: Fact Table or Factless Table: Please Suggest

Post  aseem.sb Tue Jul 13, 2010 12:44 am

Hi All,

Thanks for your valuable suggestions.

Regards.

aseem.sb

Posts : 6
Join date : 2010-07-12

Back to top Go down

Fact Table or Factless Table: Please Suggest Empty Re: Fact Table or Factless Table: Please Suggest

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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