Patent ID: 7676478
Filing Date: 2010-03-09
Classification: G06F

Abstract:
1. A data warehousing method, comprising: executing software instructions on a computer system to store a plurality of transformation templates in a plurality of transformation libraries, each transformation template including metadata objects that describe how to transform extracted source data prior to loading the source data into a data warehouse within a data warehousing system; executing software instructions on the computer system to create a unique link that corresponds to a particular transformation template, wherein the link is unique to a particular data warehousing system housing one or more transformation libraries within one or more data warehouses; executing software instructions on the computer system to associate the unique link with the particular transformation template, such that the particular transformation template is identified by the unique link in each transformation library in the plurality of transformation libraries within a particular data warehouse; executing software instructions on the computer system to instantiate an instance of the particular transformation template into a data transformation process using the unique link associated with the particular transformation template, wherein the metadata objects of the particular transformation template are mapped into an instance of a transform using executable code segments; and executing software instructions on the computer system to execute the data transformation process to transform and load the extracted source data into the particular data warehouse using the particular transformation template.