BizTalk Server Orchestration - mapping multiple tables into one

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Orchestration > December 2004 > mapping multiple tables into one





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author mapping multiple tables into one
Thomas Solbjør

2004-12-20, 5:48 pm

Hi,

Is it possible to get a structure like this:

<page1>
<name />
<address />
</page1>

<page2>
<name />
<address />
<zip />
</page2>


into a single table like this:

<post>
<type />
<name />
<address />
<zip />
</post>


I would also like to manually assign the "type" element with different
values based on what "page" the elemen originates.

Thanks

Thomas Solbjør



Nabeel Prior

2004-12-21, 2:50 am

The quickest way to achieve this is to have BizTalk create the basis of the
map for you by using a Transform shape, stipulate the 2 schemas as inputs
and your destination schema as output, and tick the check box to open
Biztalk Mapper. The map it creates for you will then contain one schema
with XSD imports of the 2 source schemas.

You can then map the two structures to the destination one, and set the
"type" field appropriately.

--

Kind Regards,

Nabeel Prior
Web: http://www.brainjar.co.za
Blog: http://www.brainjar.co.za/blog.aspx


"Thomas Solbjør" <thoSPmas.solAMbjor@gmail.com> wrote in message
news:eaxgLRs5EHA.2512@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> Is it possible to get a structure like this:
>
> <page1>
> <name />
> <address />
> </page1>
>
> <page2>
> <name />
> <address />
> <zip />
> </page2>
>
>
> into a single table like this:
>
> <post>
> <type />
> <name />
> <address />
> <zip />
> </post>
>
>
> I would also like to manually assign the "type" element with different
> values based on what "page" the elemen originates.
>
> Thanks
>
> Thomas Solbjør
>
>
>



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com