How to insert a parent and many child entries from a CSV file to mysql
Hi, I'm stuck with a job in Talend. I need to insert an entry in parent table and many child entries for its parent from a CSV file. I have inserted record in parent and I dont know how to insert multiple records in the child table and it has a foreign key relation. All Ids, primary key, are auto incremented so i couldn't how to assign the foreign id to child table. I tried it with tJoin but I can only do it for manually assigning primary key. Kindly help and thanks in advance.
Hi, The course field is not a field in my master table. Its only available in the child table. So the master table is accepting the column course. While inserting the record an error occurs "Unknown column 'Course' in 'field list'Unknown column 'Course' in 'field list'". If I'm not adding it to the master table, I'm able to insert the record. You need to deactivate up-datable and insert-able option for course column on the advanced settings tab of tMysqlOutput_1(see my pic) Could you upload your current work flow into forum so that I can understand your issue more clearly. In addition, I can send the demo job .zip file to you by e-mail. I think it will help you to know the job deeply. Best regards Sabrina
Sorry to Dig up an older thread. Found the post very useful. But don't know how to translate this step in tOracleOutput. i.e. passing a Child Table Field from the Input via advanced option in the master table tOracleOutput.
Thanks you
Hi all,
I tried to follow xdshi's instructions and I managed to create the respective Talend job (see attached). However it doesn't work......
I can't pass the “course” parameter in the “DoNotExist” path and althought there are the commits for each subJob it seems the loockup “MysqlParent” is ignored???
For your convenience I upload herein also the mysql schema of the db “parent” (two tables) as well as the csv file.
I thank you in advance
N.
parent.sql.sqlmyJob.zip.zipin.zip.zip
Hi,
I am new to Talend and I am just started learning.
I am trying to see if there are any good talent videos which explain step by step that covers most important testing concepts as below :
1) Recorde count check between source and target tables.
2) Duplication count check between source and target tables.
3) Null values count check between source and target tables.
4) Ensure the key field data is not missing or Null.
5) Check if the aggregate values and calculated measures are loaded in the fact tables.
6) Check if CDC has been applied on the incremental load table.
7) Threshold value validation check. For Example, Age attribute shouldn’t have a value greater than 100. In the date column , the month field shouldn’t have a value greater than 12)
😎 Validating parent-child relationship in the data
Would realy appreciate your help in this regard as I have to implement the ablove all test scenarios by developing talend jobs.
Please let me know if you have any job examples for the mentioned above.
