Multi Mapping in SAP PI JDBC adapter
I am using SAP PI 7.4. I am implementing one scenario for MDM-->PI--> Teradata.
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-
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,