TechTalkz.com Logo

Go Back   TechTalkz.com Technology & Computer Troubleshooting Forums > Tech Support Archives > Microsoft > Microsoft BizTalk Server

Notices

mapping one record

Microsoft BizTalk Server


Reply
 
Thread Tools Display Modes
Old 05-12-2007, 11:51 AM   #1
Venkat
Guest
 
Posts: n/a
mapping one record

I have many record nodes in the destination schema but i do need only one in
them and the rest should not be generated after the mapping. can any one
pls guide how to do this in the map? (I am not using orchestration, just
plain mapping.)

eg:

source schema Desn schema
-------------------------------------
record1-------------record1
----------------------record2
----------------------record3

i dont need these record2 and record3, note that the elements in the record2
and 3 has some default values.

thanks.
venkat.

  Reply With Quote
Old 05-12-2007, 09:38 PM   #2
Kerrey Zheng
Guest
 
Posts: n/a
RE: mapping one record

the fields will appear in destination message if they have default values in
mapping file. unless you use another mapping.
--
Kerrey Zheng


"Venkat" wrote:

> I have many record nodes in the destination schema but i do need only one in
> them and the rest should not be generated after the mapping. can any one
> pls guide how to do this in the map? (I am not using orchestration, just
> plain mapping.)
>
> eg:
>
> source schema Desn schema
> -------------------------------------
> record1-------------record1
> ----------------------record2
> ----------------------record3
>
> i dont need these record2 and record3, note that the elements in the record2
> and 3 has some default values.
>
> thanks.
> venkat.
>

  Reply With Quote
Old 06-12-2007, 12:55 AM   #3
Richard Seroter
Guest
 
Posts: n/a
RE: mapping one record

Yes, so unless you either (a) map an incoming field to those "extra" records,
or (b) set a default value, they won't exist in the final message.
--
Richard Seroter



"Kerrey Zheng" wrote:

> the fields will appear in destination message if they have default values in
> mapping file. unless you use another mapping.
> --
> Kerrey Zheng
>
>
> "Venkat" wrote:
>
> > I have many record nodes in the destination schema but i do need only one in
> > them and the rest should not be generated after the mapping. can any one
> > pls guide how to do this in the map? (I am not using orchestration, just
> > plain mapping.)
> >
> > eg:
> >
> > source schema Desn schema
> > -------------------------------------
> > record1-------------record1
> > ----------------------record2
> > ----------------------record3
> >
> > i dont need these record2 and record3, note that the elements in the record2
> > and 3 has some default values.
> >
> > thanks.
> > venkat.
> >

  Reply With Quote
Old 08-12-2007, 05:30 AM   #4
Sid
Guest
 
Posts: n/a
RE: mapping one record


> I have many record nodes in the destination schema but i do need only one in
> them and the rest should not be generated after the mapping. can any one
> pls guide how to do this in the map? (I am not using orchestration, just
> plain mapping.)
>
> eg:
>
> source schema Desn schema
> -------------------------------------
> record1-------------record1
> ----------------------record2
> ----------------------record3
>
> i dont need these record2 and record3, note that the elements in the record2
> and 3 has some default values.
>
> thanks.
> venkat.


venkat,

If you cannot supress the destination nodes through schema properties, try this:

source schema Desn schema
-------------------------------------
record1--------------------------record1
----logical & functoid (1=0)----record2
----logical & functoid (1=0)----record3

Since 1 will never equal 0, the false conidition should suppress the destination node.

Sid

BizTalk Utilities - Frustration free BizTalk Adapters

  Reply With Quote
Old 08-12-2007, 10:56 PM   #5
narasareddykunam@gmail.com
Guest
 
Posts: n/a
Re: mapping one record



In desn schema all element must be mapped.If u any element not map
it's error.

  Reply With Quote
Old 08-12-2007, 10:56 PM   #6
narasareddykunam@gmail.com
Guest
 
Posts: n/a
Re: mapping one record

On Dec 8, 4:37 am, "Sid"<> wrote:
> > I have many record nodes in the destination schema but i do need only one in
> > them and the rest should not be generated after the mapping. can any one
> > pls guide how to do this in the map? (I am not using orchestration, just
> > plain mapping.)

>
> > eg:

>
> > source schema Desn schema
> > -------------------------------------
> > record1-------------record1
> > ----------------------record2
> > ----------------------record3

>
> > i dont need these record2 and record3, note that the elements in the record2
> > and 3 has some default values.

>
> > thanks.
> > venkat.

>
> venkat,
>
> If you cannot supress the destination nodes through schema properties, try this:
>
> source schema Desn schema
> -------------------------------------
> record1--------------------------record1
> ----logical & functoid (1=0)----record2
> ----logical & functoid (1=0)----record3
>
> Since 1 will never equal 0, the false conidition should suppress the destination node.
>
> Sid
>
> BizTalk Utilities - Frustration free BizTalk Adaptershttp://www.topxml.com/biztalkutilities


take one content functiod assign null value and assign to all elements
in desn schema except you required element. IN source schema you take
only requried element. There is no need to mapp all source elements.
  Reply With Quote
Reply

Thread Tools
Display Modes



< Windows Help - MS Office Help - Hardware Support >


New To Site? Need Help?

All times are GMT +5.5. The time now is 03:51 PM.


vBulletin, Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright © 2005-2009, TechTalkz.com. All Rights Reserved - Privacy Policy
Valid XHTML 1.0 Transitional