A method, apparatus, and article of manufacture for a data warehouse programs architecture. Data in a database stored on a data storage device is transformed. Initially, a program template is retrieved that contains parameters. A business view is invoked with the program template. Under control of the business view, a transformation program is invoked that transforms source data to generate target data using the parameters provided in the program template.