Subject:Mapper generating XSLT, populates children records into teradata database, but not multiple children Author:Ryan Sapp Date:17 Aug 2011 08:53 AM Originally Posted: 17 Aug 2011 08:48 AM
I am using the mapper in stylus studio to produce an xslt that will be used to shred input xml into our staging teradata database. It mostly works great, we successfully shredded a few records into the database. However, when we try and add two child records, the shredder only recognized the first child and therefore only enters 1 child(flight leg) into the database instead of the desired 2(or more). Attached is the XSLT file and the input xml file. Is there a setting in the XSLT that should let the shredder know to look for multiple children? Help is appreciated.
Thanks
Ryan
Subject:Mapper generating XSLT, populates children records into teradata database, but not multiple children Author:Ivan Pedruzzi Date:17 Aug 2011 10:33 AM
Hi Ryan,
I did small changes to take into account the repeatable elements.
You can accomplish this drawing a links using the right mouse button then picking "Create repeatable link"
I also had to change the namespace in order to match the sample input document.
See attached XSLT, let us know if can help you further