Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Multi Mapping in SAP PI JDBC adapter

Hi Experts,

I am using SAP PI 7.4. I am implementing one scenario for MDM-->PI--> Teradata.

Source structure:

<MT_Employee>

     <Record>

          <Details>

               <Name/>

               <Age/>

               <Educational_Details>

                    <College/>

                    <Department/>

               </Educational_Details>

               <Professional_Details>

                     <Company>

                     <Total_Experience>

               </Professional_Details>

               <Hobby>

           </Details>

     </Record>

</MT_Employee>

The requirement is: Sorce details (Name, Age, Hobby)  will go to target "DT_Employee" table. Source "Educational_details" will go to target "DT_EduDeatis" table. Source "Professional_Details" will go to "DT_ProfDetails" table. If the source file contains one record, then I am able to achieve this. But if the source file contaibs multiple record, then only one record (first record) is getting generated in the target table. Please advise how to achieve the multiple record load if the source file contains multiple records.

Note:  I have created the target structure as below-

<StatementName1>

     <DT_Employee action="INSERT">

          <table>DT_Employee</table>

          <access>

               <Name/>

               <Age/>

               <Hobby/>

          </access>

     </DT_Employee>

</StatementName1>

<StatementName2>

     <DT_EduDetails action="INSERT">

          <table>DT_EduDetails</table>

          <access>

               <College/>

               <Department/>

          </access>

     </DT_Edu_Details>

</StatementName2>

<StatementName3>

<DT_ProfDetails action="INSERT"> 

          <table>DT_ProfDetails</table>

          <access>

               <Company/>

               <Total_Experience/>

          </access>

     </DT_ProfDetails>

</StatementName3>

Mapping Logic: Detail-->StatementName1 (Occ:1..Unbounded)

                              Educational_Details-->Exists-->CreateIf-->StatementName2 (Occ: 0..Unbounded)

                              professional_Details-->Exists-->CraeteIf-->StatementName3 (Occ: 0..Unbounded)

Thanks & Regards,

Moumita


Not what you were looking for? View more on this topic or Ask a question