cancel
Showing results for 
Search instead for 
Did you mean: 

Performance issue loading XML File to Teradata table

Former Member
0 Kudos

Hi All,

Looking for help on improving performance loading from XML File in BODS.We are having a 600 MB XML file with about 400 columns. When we try to load it to Target table (Teradata) is takes around 4 hrs. We have tried using XML Pipeline but as the structure has more than 20 sub hierarchies it will be complex using so many XML_Pipeline transforms and joining all these will again reduce the performance.

If any body has come across similar situation would appreciate any suggestions or methods which could improve the performance and decrease the load time.

Thanks in advance.

regards,

Madhavi

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member187605
Active Contributor
0 Kudos
  • Have you tried using a single XML_Pipeline transform as a starting point for your data flow. That might help, because streaming data thru the flow.
  • Have you tried increasing your data flow's DOP (degree of parallelism)? Does that have any impact?