title: Is it good practice to have foreign keys in a datawarehouse (relationships)?
body: <p>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.</p>