CODEWITHSUNDEEP
joinrelational-databasetalend
user2544374
user2544374

Reputation: 5

Talend csv to relational db tables : foreign key setting

I'm a Talend beginner and searched about this simple problem, many have posted the web about the same problem but no solution appeared...

I have a csv file with 50 fields, I want to load it into a three tables relational database with Talend. I did a tMap, everything is ok except for foreign key : I don't know how to set them.

Here is my job enter image description here Here is my tMap enter image description here

I hope someone could give me the simple exact solution

Cheers

Pascal

Upvotes: 0

Views: 243

Answers (1)

Théo Capdet
Théo Capdet

Reputation: 1062

You can do it in two Time.

(CSV) -> (tmap) -> (organisation_output) | subjobok | | (organisation_input) | | (CSV) -> (tmap)-> (country and adress output)

Do a INNER JOIN in the second tmap on column that have unique value for each row. And load 'ImpID' of your organisation input in the two other output table Impid column.

Upvotes: 0

Related Questions