If anyone were to come into my company and see how these generic lookup tables have completely eradicated referential integrity and made data warehousing a total nightmare, they would stay well clear.

From my experience, generic lookup tables are produced by pressure from lazy developers who bully the dba guys into creating them.

Remeber, it's not always about data going in, you have to think how it's going to come out the otehr end.