Interesting problem in Mapper

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Interesting problem in Mapper

Viewing 0 reply threads
  • Author
    Posts
    • #22173

      Hi,

      I have to create a map to process the incomming message and to convert it into required format. Incomming message contains employee information with its certification detail. Employee has mutiple certifications. Each certification and its detail are store as a seperate record nodes in the message. We need to extract certification detail for MCSD only. Both incomming and outgoing messages are given below. How can we create a mapper to fullfill this requirement.

       

      Incomming Message

      ===============================

      <ns0:Emp
      xmlns:ns0
      =”http://tempuri“>
      – <PersonalInfo>
        <ID>1</ID>
        <FName>FN</FName>
        <MName>MN</MName>
        <LName>LN</LName>
        </PersonalInfo>
      – <Certification>
        <CertID>1</CertID>
        <CertImg>sdjgfsdgfhjgfsdfsdgfsdfgsdfsdggfgfsdgsfsdfgsdfgsj</CertImg>
        </Certification>
      – <Certification>
        <CertID>2</CertID>
        <CertImg>vbnmbvxcvxcbvbvnmxcb</CertImg>
        </Certification>
      – <Certification>
        <CertID>3</CertID>
        <CertImg>reytqwryetrqwtyerqwtyerqwtyqwertyqwretyrqwetyrqwtyertyqwretyqw</CertImg>
        </Certification>
      – <CertificationDetail>
        <CertID>1</CertID>
        <Year>1990</Year>
        <Name>MCP</Name>
        <Country>USA</Country>
        </CertificationDetail>
      – <CertificationDetail>
        <CertID>2</CertID>
        <Year>1991</Year>
        <Name>MCPD</Name>
        <Country>USA</Country>
        </CertificationDetail>
      – <CertificationDetail>
        <CertID>3</CertID>
        <Year>1992</Year>
        <Name>MCSD</Name>
        <Country>USA</Country>
        </CertificationDetail>
        </ns0:Emp>
      Outgoing Message
      ========================

      – <ns0:Employee xmlns:ns0=”http://tempuri“>
      – <Certification>
      – <MCSD>
        <EmpID>1</EmpID>
        <FullName>FN MN LN</FullName>
        <CertID>3</CertID>
        <CertImg>reytqwryetrqwtyerqwtyerqwtyqwertyqwretyrqwetyrqwtyertyqwretyqw</CertImg>
        <Year>1992</Year>
        </MCSD>
        </Certification>
        </ns0:Employee>

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.