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

Null Foreign Key

3 posters

Go down

Null Foreign Key Empty Null Foreign Key

Post  kkraemer 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

Back to top Go down

Null Foreign Key Empty Re: Null Foreign Key

Post  BoxesAndLines Wed Mar 04, 2009 7:28 pm

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

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

Back to top Go down

Null Foreign Key Empty Re: Null Foreign Key

Post  kkraemer 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

Back to top Go down

Null Foreign Key Empty Re: Null Foreign Key

Post  BoxesAndLines Thu Mar 05, 2009 10:59 am

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

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

Back to top Go down

Null Foreign Key Empty Re: Null Foreign Key

Post  BrianJarrett 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.
BrianJarrett
BrianJarrett

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

Back to top Go down

Null Foreign Key Empty Re: Null Foreign Key

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