1. A machine-implemented method residing in an non-transitory computer-readable medium and for executing on a machine, the machine configured to process the method, comprising: acquiring, by the machine, schemas for applications that store data in a data warehouse, unique identities for the applications are used to access a policy store and obtain the schemas that define input and output data used and produced by the applications; automatically, by the machine, applying rules to detect a plurality of data types defined in the schemas that match in response to patterns defined in the rules, wherein each data type is defined in a different one of the schemas; and automatically and dynamically generating, by the machine, a master schema for the data types that merges each definition for each data type from each data type's corresponding schema into a single master definition that defines the data types as a whole within the master schema.