Loading data from xml file to db

My source is in the below path….

 

Create one data server as shown below …

 

 

Fill the properties tab as shown below…

 

 

 

 

 

Create one physical schema as shown below..

 

Go to logical architecture and create new logical schema and set context as below..

 

Again come to physical schema and set context…

 

 

 

 

 

Create one folder and in that create one model  and set model prop as below…

Go to selective rev eng and rev eng the tables,

We can see 2 tables automatically after rev eng…

 

The original data is in below table because it looks like child table means it is having in detailed information

 

 The below is other table which is looking like parent table…

 

Now drag the child table and target table into mapping

 

Set integ type as control append…

Set km’s as shown below..

 

 

 

And finally the target table is having data…