1. A system for generating an information integration flow design (IIFD), the system comprising: a processor configured to receive a conceptual model of the IIFD, the conceptual model having an extract phase, a load phase, and a transformation phase; an extract unit connected to the processor configured to model an interface between a data source information object and a transformation function based on at least one extract hypercube; a load unit connected to the processor configured to specify at least one load hypercube and a data warehouse target object; a transformation unit connected to the processor configured to express one or more steps as a hypercube operation; and a translation unit connected to the processor configured to generate the IIFD based on the conceptual model.