Search code examples
talend

Table to 2NF in Talend

How can I get a table to 2NF in Talend?

Currently I have:

Marc   Mayr    12/12/1980    Someitem
Marc   Mayr    12/12/1980    Somethingelse
Steven Ming    08/09/1981    Completelydifferent

So I want to split person and item data into two separate tables. How can this be done using Talend? (Remark: I don't have a primary key yet, but I can use a combination of name and birthday - already checked for distinct values.) Thanks in advance!

Solution

  • You can use something like this:

    tFileinput -> First_Name,Second_Name,Year -> tMySQLOutput (persons) (set the table to have an ID with auto increment as the primary key)

    tFileinput           ->     
                        tMap -> Item
tMySQLInput(persons) ->

    So basically there are 2 different step:

    • Step1: create the persons table
    • Step2: map the persons the the inputfile and populate the orders table.

    This can be done via SQL as well.