The first two recipes show how
tXMLMap can be used to map between XML formats visually, much like the
tMap component; however, it can become overly complex and difficult to manage when there are multiple levels of hierarchy and multiple loops within the XML. This recipe shows how we can deconstruct a more complex XML record into individual sets of data while ensuring that the hierarchical relationships between the data are not lost.
Open the job
you view the input file
chapter09_jo_0040_orderDate.xml, you will see that we have a hierarchy of customer that has many orders, and orders have many items.
First, we will create a customer schema using ...