Is it good practice to have foreign keys in a datawarehouse (relationships)?

Posted by Lieven Cardoen on Stack Overflow See other posts from Stack Overflow or by Lieven Cardoen
Published on 2010-04-22T12:44:57Z Indexed on 2010/04/24 13:33 UTC
Read the original article Hit count: 172

I think the question is clear enough. Some of the columns in my datawarehouse table could have a relationship to a primary key. But is it good practice? It is denormalized, so it should never be deleted again (data in datawarehouse). Hope question is somewhat clear enough.

© Stack Overflow or respective owner

Related posts about datawarehousing

Related posts about database