Social Welfare: cut the subsidy for the Retarded of the receipt of the smart card in a timely manner
Social Welfare: cut the subsidy for the Retarded of the receipt of the smart card in a timely manner 18/08/2010 Warned that the Social Welfare Department in the Ministry of Labour and Social Affairs covered pieces of subsidies in the event of not

Transitive Dependency
There are many dimensional tables in our organzation has got transitive dependency in them and we are forced to adopt different SCD types like type 1 and type 2 I will explain my scenario with an example(see table below) ,the Item dimension has got

Joining Type II Dimension Hierarchy directly to Fact versus through a Dimension table
Given I have 3 tables, Workforce Event Fact, Department Dimension (Type II SCD), and a Department Hierarchy (Type II SCD), and assuming the DEPTIDs in the Department Dimension table are reflected in a BASEDEPTID field in the Dept Dimension hierarchy table