topic Re: Parent and Child record insertion in Talend Studio

Parent and Child record insertion

Anonymous — Thu, 01 Nov 2018 14:39:49 GMT

This is a sample CSV. I need to insert Student and Subject in their respective master tables and Marks in the Child table. The table structure as follows.

Input is like :

Mark,CS,23
Mark,CE,25
Mark,DB,27
John,ACN,21
John,Maths,30
Tom,Physics,26

Please Note : Some master data is already inserted and some might be new and need to insert. Please suggest your views on this

Re: Parent and Child record insertion

Anonymous — Thu, 01 Nov 2018 18:26:41 GMT

Hi,

You will have to first store the Student and Subject tables as first stage. Since same data will be coming multiple times in transaction table, you will have to aggregate the data before loading the data to Student and Subject tables. Since same data is coming again, you will have to use Action on Data as "Insert or Update". In the schema, you will have to select the Key column also so that it will be used as the column for input/update

If the answer has helped to resolve your query, could you please mark the topic as closed? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: Parent and Child record insertion

Anonymous — Fri, 02 Nov 2018 06:59:33 GMT

Thanks @nthampi for your response, i would try this but does it maintain the same transaction for master and detail data?

Re: Parent and Child record insertion

Anonymous — Fri, 02 Nov 2018 07:07:27 GMT

Absolutely! This is a classic way of storing the data in normalized way where we are first storing the master tables and use the keys from master table to store the data in transaction table.

Could you please mark the topic as resolved if the answer has helped you. Kudos are also welcome

Warm Regards,

Nikhil Thampi