I have talend job that works as designed, except that I need to create a parent-child relationship between the two custom objects and to do so i need the first custom object to load before the second custom object.
I have read a bunch of documentation, regarding the tFixedInputFlow, but because I need the output of the tmap for both tsalesforceoutput components I don't believe this will work. I have also tried to use tSleep to pause the second/related custom object, so the first custom object can load completely and this did not work either.
What am I missing?
I have attached a simple representation of the real job, and all I want to do is load the patient output completely, before the patient_encounter output.
Your help is greatly appreciated.
Solved! Go to Solution.
It's always the last thing you try that works.
I got it working by using the tSleep and most importantly I unchecked the "Extend Insert" on the Patient tsalesforceoutput. I believe by unchecking the "Extend Insert" each patient record is committed one by one, thus allowing the Patient_Encounter to find the related patient record on insert.
One clarifications. The tHashout component only has "On Component Ok" trigger, I assume I use that correct? The tHashInput has both "On Component Ok" and "On Subjob Ok". So I use the "On Subjob Ok" trigger to connect to child object flow, correct?
Thanks for your help on this.
I don't think it is exactly what I am after. I am processing a set of database records and splitting the data via a tmap into two outputs. Output 1 is used to create a patient record in a salesforce custom object, and Output 2 is used to create a patient encounter in a salesforce custom object (and relates it to the previously created patient records). When I create the patient encounter I am using the relations lookup and need to make sure all the patient records have all been created before the patient encounter does the lookup.
The challenge is I have to process the source record all the same time, so I am trying to make sure the patients are created before the related patient encounters.
Hope this helps. Thanks again for the help.
Ok, you have me sold.
I'm still confused on your suggestion, if I need to trigger the subjobs using the two outputs from the tMap. Your suggestions was the single output of the TMssqlInput, this won't work in my scenario (or I am missing something). I have attached an image of the flow. Where would i insert the thashout and thashinput to get the Add_EhrEncounters to run second?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
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