In this data integration use case we will show how to use the Mapper's Key Function to consolidate multiple source records into a hierarchical header and detail sequence.
Incoming is a flat file that contains purchase orders and each line contains the PO and the line items. Mapping will convert the flat file into a Header and Detail formatted output. Purpose of the use case is to show you the complexity of data translation and how user can easily convert data to any format.
In this use case we will use Data Interface to setup this ETL process. Source location is tied to a File Event which polls for a source data file and then automatically executes the interface and produces the output file.
Refer to the attached use case walk-through document, sample output XML and the input file.