How to transform one table into three with foreign keys and associative entity

Anonymous — Fri, 19 Oct 2018 10:50:54 GMT

Hello,

I'm quite beginner with talend and i don't know how to load data from one table into three new tables (associative entity), see picture below.

Both ID's from person and coordinate are generated automatically (auto_incremented ID's) and I need to get them in order to fulfill my last table person_coordinate. I have already find and use solution about one similar case when there is only one "parent". I had to disable "extend insert" then add a rule with the expression "LAST_INSERT_ID()" but that can't be applied in my current case because I need two ID's...

Thanks,

Guillaume

Re: How to transform one table into three with foreign keys and associative entity

Anonymous — Tue, 23 Oct 2018 08:23:39 GMT

Hello,

Please stick to one topic:https://community.talend.com/t5/Design-and-Development/Transform-1-table-into-3-tables-using-foreign-keys-and/m-p/137994#M85744 so that we could pay individule attention to it.

Best regards

Sabrina

topic How to transform one table into three with foreign keys and associative entity in Talend Studio

How to transform one table into three with foreign keys and associative entity

Re: How to transform one table into three with foreign keys and associative entity