Patent ID: 7143076

Claim:
A computer program product comprising: a computer-usable medium having a computer program for transforming a source data structure to a destination data structure embodied therein, said computer program configured to: obtain a source data structure comprising a set of source tables, a set of source fields, a set of source records, a set of source table relationships, and a set of source values; join a plurality of source tables selected from said set of source tables; parse a source field selected from said set of source fields and split said source field into a plurality of destination fields; partition a plurality of source fields selected from said set of source fields into a combined destination field; transform a source value into a destination value having a different data type or different unit of measure; obtain transformation data comprising information associated with at least one set selected from said set of source tables, said set of source fields, said set of source records, said set of source table relationships and said set of source values and at least one destination data structure; access a first source field of said source data structure and display all existing values for said first source field and obtain transformation data associated with all existing values to allow for field-at-a-time handling of said set of source fields to eliminate run-time exceptions; transform said at least one set selected from said set of source tables, said set of source fields, said set of source records, said set of source table relationships and said set of source values into said at least one target destination.