I have a database where i have for example a table People with different column :
I picked up the column title to have a table Title (like Mister, Miss, ...) with different title in table People (DISTINCT sql).
However i would like to have a link between this new table (Title) and the table People (with a foreign key) but i don't know what to use.
So, if Lucas is a people with Mister as title, i would like his new column (so my foreign key) will be the id of the value mister in the table Title like :
ID NAME AGE TITLE
1 Lucas 15 Mister
2 Marthe 28 Miss
3 Peter 48 Mister
4 Hugo 23 Mister
and have after :
TABLE PEOPLE TABLE TITLE
ID NAME AGE FK_TITLE ID NAME
1 Lucas 15 1 1 Mister
2 Marthe 28 2 2 Miss
3 Peter 48 1
4 Hugo 23 1
Which component can i use to do that ? I thought tMap was the component i needed but i didn't how to do that with tMap...
Can you help me ? :-(
PS : I Hope you understood me, my english is not very good
Pending a response from you,
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables