Eight Stars

Load a single Table from a xml file with multiple Hierarchy(Loop)

Hi All,

We have a xml File which have 3 Hierarchies.I need to loop all 3 hierarchies and load it into a single Table using One Job. Can anybody please suggest how to achieve this. We have currently loading 3 hierarchies in 3 Different Tables using 3 Different Subjobs.

3 REPLIES
Eight Stars

Re: Load a single Table from a xml file with multiple Hierarchy(Loop)

Can anyone help with this please? @rhall_2_0@shong?

Eight Stars

Re: Load a single Table from a xml file with multiple Hierarchy(Loop)

Can anyone help with this please

Nine Stars

Re: Load a single Table from a xml file with multiple Hierarchy(Loop)

Hi Abhi90,

Is it possible to provide some sample data?

 

Regards,

 

 

Veeru Boppudi