Split one big table in two related tabel

[Anonymous]

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

[manodwhb · Accepted solution]

@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