Patent ID: 7418449

Claim:
A method for loading data into a datamart, the method comprising: identifying business data in a first format from a real business process; identifying a desired second format; iteratively designing a transformation algorithm that transforms the business data in the first format into the second format, by, (i) designing a first set of transformations, (ii) implementing the first set of transformations in computer executable code in a form of a declarative language; (iii) sequentially executing the computer executable code on business data in the first format and generating business data in the second format, by, identifying blocks in the code, determining dependencies between the blocks, and executing a particular block only after all blocks upon which that particular block depends have been executed; (iv) recording of any missing transformations or other problems; (v) designing an augmented and improved set of transformations; and repeating steps (i)-(v) more than once; and storing the business data in the second format in a datamart; and indicating to a user a change in the real business process based upon the business data in the second format.