I have to process on xml with multiple child loop elements...could you please suggest design...currently Job is build in Abinitio and we are trying to convert it to Talend...in current job design...child loops are normalized one by one...how the design will look in Talend...I tried to create MetaData from XSD...what would be the XPath if need to process all child loop elements...can I do in one step or divide in steps?
Could you please elaborate your case with an example with input and expected output values?
PFA XML Sample.
Parent loop is - MasterAgreement
Child Nodes are - SecurityAgreementList , MultibranchEntityList, FirmBranchesList
Need to write data after normalizing to Oracle so scenario is if there are multiple records for first than I have to create those many rows...after that go to second child and again if there are multiple records...create those many rows and so on.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema