I need to save many files in two tables oracle
- table parent : save filename and sysdate
- table child : save content file + PK of parent table
Thank you in advance
I would recommend you use OnSubjobOk instead of OnComponentOk on the connection to tOracleInput_1.
If the purpose of tOracleInput_1 is to retrieve the records from the parent table in order to provide the keys for the insert into the child table, you probably want to make that flow your lookup and the flow from your tFileInputPositional the main. Beyond that, we'll need more details about the problem you are experiencing. Are you getting an error message? Is the job finishing but not writing the expected information to one or both of your tables?
What's the error you are getting for your subjob 2(child)?
Here is a KB article about:https://help.talend.com/pages/viewpage.action?pageId=190513190
Hope it will be helpful.
Thanks for your replies. I have no errors in my job, but i have the same contents in my two child tables.
name : file1.txt
name : file2.txt
In my table, Parent, i have two records, file1.txt and file2.txt, => correct
But in my tables : child 1 and child 2 i have the same contents.
i changed the main flow in tMap, and the query from the database in lookup.
now i get the contents two files in the same table 1.