I have to design a Talend program with a Flat File input to an Oracle Database where I have a header record to store and 6-7 child records I need to store with Foreign key pointers in the header. Am looking for a program flow and or video or steps how to do this - the more detailed the better as this will be my 1st real life Talend How do I capture the Foregin keys and store them in the Header record? Obviously I can't do a commit to the database until I have stored all the children records and updated the header record to avoid ophans - Have don this in other languages, just have no Idead how to get started in Talend
Thanks for the help
Please let us know if this article is helpful for you:https://community.talend.com/t5/Design-and-Development/Passing-a-value-from-a-parent-Job-to-a-child-...
Thank you Sabrina -
This gives me a start - the State of RI decided to go with Talend after we came on board and no one knows it - I have been doing the videos & tutorial, but when we finally saw the Oracle database I realize we/I need a lot more guidance. I have a lot Informatica ETL experience, but nothing with Talend. The User is sending a flat file and I have to Create the Header record and then the child records and update the Header with the pointers from these children record. This gives me a start Much Kudos, I read the in MySQL you could capture the :Last Insenter Key, but not in Oracle - Is that so? The first project will be straight add of the New Header Vendor Records, & the child are Bank, Address Etc. Have a flow in my head but no Talend experience on how to do it. Have written my boss and said we need to get some help - Know of anyone in RI area
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.