Investment Inc. uses an online tracking system to maintain customer transactions and contact details. The company can use their data to identify premium clients who most heavily use their services, as well as those who are less active clients.

They need to create a mapping that transforms daily logs with all buy and sell transactions into customer-specific data. The company online system stores transaction logs in XML format. The mapping needs to use a Data Processor transformation that inputs buy and sell transactions, sorts the data relevant to each customer, and outputs customer contact data and the total dollar amount of each customer's daily transactions..

The following figure shows the mapping in this example:

The mapping contains the following objects:

Read_XML_TO_XML

The source that contains the path to the file with transaction data and client data. Reads client and transaction data from an XML file.

mapper_Transactions

A Data Processor transformation that transforms an XML input hierarchy into an XML output hierarchy.

Write_PARTNERS

A target path to the file that stores the transformed data every time you run the mapping.

The mapping uses the Read_XML_TO_XML flat file to look up the transaction log. The mapping processes and transforms the data with the mapper_Transactions mapping. Then the mapping stores the output in the target path listed in the Write_Partners flat file.