I have a XML file which contains several “Estate” records. Every “Estate” record has several categories like <customer_information>, <estate_information>, <picture_information>, <map_information>, etc. which contain more detailed information. Every information tag then has to be mapped against a schema of a DB-table in the database “Estate”. We have a table “customer_information”, “estate_information”, “picture_information”, “map_information”, etc.
My first idea is to split the big XML file into several autonomous “Estate” XML files. Then map all single “Estate” information tags against a schema of every db table. Is it possible to split the big XML file with several Estate records into several single Estate XML files with the pipeline? If so can I do the mapping inside the receive port immediately after the splitting inside the pipeline?
After that I would like to send the mapped tag informations to the associated DB table.
For a better understanding I have created a word document with a drawing of my idea.
http://rapidshare.com/files/415410452/WorkToDo.doc