Foreign keys and views

• Piers-167152

  SSC-Addicted

  Points: 477

  More actions

  October 11, 2007 at 4:33 am

  #178838

  I have often heard that using views in a data warehouse is good practice. My question concerns keys from fact tables to dimensions views.

  If I create, say, a date dimension table and then create several views on this, would the fact table need multiple keys to the one date dimension table, or is there a way to create foreign keys to the views?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737761

  More actions

  October 11, 2007 at 6:45 am

  #741170

  Post moved to a more appropriate forum.

  Sorry, not sure what the answer is, but hopefully someone will chime in.