TRANSFORMING AND LOADING DATA FROM A SOURCE DATA SYSTEM TO A TARGET DATA SYSTEM

In one embodiment, a system transfers data between source and target systems. The system receives a module including procedural logic for transforming source data of a source data model to a target data model to produce one or more target data objects for the target data model. The procedural logic is expressed by one or more elements of a domain specific language implemented by an underlying computer language. The one or more elements define mappings and structure for the one or more target data objects. The module is executed to produce the one or more target data objects for loading in the target system in accordance with the mappings and structure defined within the procedural logic by the one or more elements. Embodiments of the present invention further include a method and computer program product for transferring data between source and target systems in substantially the same manner described above.