Referential integrity in a relational data warehouse. Is it worth it? and what are the alternatives?

Question

If you needed to create a relational data warehouse of biblical proportions using SQL Server 2008, would you use foreign keys to ensure data integrity or would you use other methods?

I like foreign keys because you only need to get them right away, and they are always there to protect integrity. I was thinking of disabling, loading, enabling the route.

Any thoughts?

Thanks in advance.

Answer 1

-, , () . "" , SQL?

Answer 2

, ! , - , . , , . () , , ?

, - , - , .

, , - , , . , , . , ( ), , , , .

, !

Answer 3

, . , , , , .

, : ; ; , ; , .