Skip to Content
0
Former Member
Nov 14, 2009 at 09:28 PM

Tricky Mapping Scenario : Leads pls

48 Views

Hi folks i have a tricky mapping requirement.

I would appreciate your help. I think i need to go in for Java mapping but i am not very good at it. If required can someone guide me with doing it in DOM?

Thanks,

Hank

Source Structure

RequestBody->Summary(1-unbounded)

ManagerName(1)

ManagerID(1)

DistributerID(0-1)

Distributer(0-1)

Seller(0-1)

SellerID(0-1)

Here is how it goes:

-The summary has details about a manager.

-A manager may either have a Distributor directory under him - If he has a distributor under him , that distributor will always have a seller assigned to him.

- A manager can have a Seller directly assigned under him.

Pls look at this sample Source and Target XML desired

 
<RequestBody>
	<Summary>
		<ManagerName>Keith</ManagerName>
		<ManagerID>K09090</ManagerID>
		<DistributerID>Raymond</DistributerID>
		<Distributer>R87877</Distributer>
		<Seller>Alex</Seller>
		<SellerID>A9876</SellerID>
	</Summary>
	<Summary>
		<ManagerName>Keith</ManagerName>
		<ManagerID>K09090</ManagerID>
		<DistributerID>Robert</DistributerID>
		<Distributer>R11111</Distributer>
		<Seller>Blake</Seller>
		<SellerID>B09976</SellerID>
	</Summary>
	<Summary>
		<ManagerName>Keith</ManagerName>
		<ManagerID>K09090</ManagerID>
		<Seller>Marie</Seller>
		<SellerID>M87656</SellerID>
	</Summary>
	<Summary>
		<ManagerName>John</ManagerName>
		<ManagerID>J97654</ManagerID>
		<Seller>Charlie</Seller>
		<SellerID>C98765</SellerID>
	</Summary>
	<Summary>
		<ManagerName>John</ManagerName>
		<ManagerID>J97654</ManagerID>
		<Seller>Drew</Seller>
		<SellerID>D98455</SellerID>
	</Summary>
</RequestBody>