topic Split one big table in two related tabel in Talend Studio

Split one big table in two related tabel

Anonymous — Tue, 02 Apr 2019 13:05:29 GMT

Hi, I dont know how to start on my Problem. Here is it: 1) Today: I have one big table with round about 40 columns and ofcourse a PK 2) Future: I want to make 2 tables with splitting up the data. (One Table with the main data and second with some Special informations). A new ID field is the new PK for both tables. The relation between this two tables and records musst still exists. After the Migration the old PK should be wasted. Perhaps any sugesstions how i could start here and which components i needed. Im using Talend Open Studio for Data Integration. Thank you, Jens

Re: Split one big table in two related tabel

manodwhb — Tue, 02 Apr 2019 13:14:57 GMT

@jensbr , You can do with the below way.

tDBInput --> tmap---> tDBoutput(Main table)

tHasoutput

On Sbjob ok from tDBinput

tHasInput--tMap--tDBoutput(second table)

Lookup Main Table