Null Foreign Key

View previous topic View next topic Go down

Null Foreign Key

Post  kkraemer on Wed Mar 04, 2009 12:38 pm

So is this an exceptable practice in the Data Warehouse?

I have a situation where an employee is terminated and the reporting relationships no longer exists.

kkraemer

Posts : 2
Join date : 2009-02-03
Location : Chicago

View user profile

Back to top Go down

Re: Null Foreign Key

Post  BoxesAndLines on Wed Mar 04, 2009 7:28 pm

The relationship existed when the fact row was created. Do you want to alter history?
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Null Foreign Key

Post  kkraemer on Thu Mar 05, 2009 10:39 am

There is no requirement to maintain historic reporting relationships

kkraemer

Posts : 2
Join date : 2009-02-03
Location : Chicago

View user profile

Back to top Go down

Re: Null Foreign Key

Post  BoxesAndLines on Thu Mar 05, 2009 10:59 am

The I offer that you do not need a data warehouse.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Null Foreign Key

Post  BrianJarrett on Thu Mar 05, 2009 3:00 pm

I'm not familiar with your warehouse but to me this sounds like it could be solved pretty easily by flagging your employee dimension record. The simplest solution being an 'active' boolean flag. That could be filtered at the report level to exclude anyone not currently active (termed). It could also be a term date that gets filtered out on the report.

I'd need more requirements in order to design something more elegant.
avatar
BrianJarrett

Posts : 61
Join date : 2009-02-03
Age : 43
Location : St. Louis, MO

View user profile

Back to top Go down

Re: Null Foreign Key

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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