i have an issue loading parent and child objects simultaneously using tXMLMap and tESBConsumer components in Talend.
The issue I was facing :
For one parent record, there might be multiple records in child table referred by a unique attribute. While running the job, all the records in parent table are getting updated correctly but in the case of child table, only one among the multiple records is getting updated.
Example :: PR the parent object has 17 records
PRLINE the child object has 27 records
PRNUM is the reference attribute for both the tables.
PRNUM is the primary key in PR table and is unique in the table.
The combination of PRNUM and PRLINENUM is unique in PRLINE table.
For each PRNUM in PR table there can be multiple PRLINENUMs in PRLINE Table.
We expect 17 records should get inserted into target PR table and 27 in child PRLINE table.
Below are the screen shots of my job.
tMap settings :: loadonce, innerjoin,allmatches.
tXMLMap settings :: PR (group by) PRLINENUM (loop by),
Can anyone help me in resolving this issue.
Let me know if any further information is required.
While running the job, all the records in parent table are getting updated correctly but in the case of child table, only one among the multiple records is getting updated.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema