如何将源模式映射到目标模式 [英] how map source schema to destination schema

问题描述

大家好，



我有两个架构源和目的地，结构如下。





< ns0：productreq xmlns：ns0 =http：//ProductOrder.ProductResuest>

< custmorid> CustmorId_0

< requeststid> RequestId_0

- < products>

< productid> ProductId_0

< quantity> Quantity_0



- < shippinginfo>

< city> City_0

< state> State_0

< country> ; Country_0





和



< ns0：productdata xmlns： ns0 =http：//ProductOrder.RequestData>

< custmorid> CustmorId_0

< requestid> RequestId_0

- <产品>

< productid> ProductId_0

< quantity> Quantity_0

< availabilitybequnty> AvailablebeQunty_0

< ; priceperqty> PricePerQty_0


- < shippinginfo>

< city> City_0

< state> State_0

< country> Country_0







现在我要映射如下



为每个productid，recored从数据库中提取并映射到destiantion架构。

解决方案

循环productd节点并使用数据库functoid从数据库中获取数据并将其映射到目标模式。



感谢

Hi All,

I have two schema source and destination with following structure.


<ns0:productreq xmlns:ns0="http://ProductOrder.ProductResuest">
<custmorid>CustmorId_0
<requestid>RequestId_0
- <products>
<productid>ProductId_0
<quantity>Quantity_0

- <shippinginfo>
<city>City_0
<state>State_0
<country>Country_0


and

<ns0:productdata xmlns:ns0="http://ProductOrder.RequestData">
<custmorid>CustmorId_0
<requestid>RequestId_0
- <products>
<productid>ProductId_0
<quantity>Quantity_0
<availabequnty>AvailabeQunty_0
<priceperqty>PricePerQty_0

- <shippinginfo>
<city>City_0
<state>State_0
<country>Country_0



Now i want to map as follows

for every productid ,recored are fetched from database and mapped to destiantion schema.

解决方案

Hi,

Loop around the productid node and use database functoid to fetch the data from database and map it to destination schema.

Thanks

这篇关于如何将源模式映射到目标模式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！