The Foreign Key Test plan provides an easy to use wizard driven test plan for validating the parent - child relations between tables. In a star schema, this test plan can be used to validate the Fact to Dimension joins and orphan records. 

Video on the Foreign Key test plan: