tXMLMap taking long time to process XML data to load to snowflake

[vvazza10]

I have an XML file (2MB) that was various child elements - Employee, chemical, electrical, transport, mechanical, which I am trying to load to Snowflake table. When the job was executed, tXMLMap seem to take most of the time in processing the data.

The tXMLMap read is taking around 15-20 minutes to complete for a small set of data. The job design would look as below -

Please advise how to design a job that reads XML which contains various sub elements and attributes.

[gjeremy1617088143]

the purpose of tExtactXmlField in my scenario is to be used in parrallel job, so you read the xml for chemical, you read the xml for Electrical And all the read are made in parallel.

[Anonymous]

You can use tReplicate component, this component replicate the source data so that you can use the source data many times.