topic Re: Create a foreign key in Talend Studio

Create a foreign key

Anonymous — Thu, 26 Jan 2017 22:52:28 GMT

Hi,
I am a novice in ETL and Talend. I have a requirement to create foreign keys for various tables. I know how to make a sequential primary key.

Numeric.sequence("s1",1,1)

I am oblivious on how I can make a primary key of one table into a foreign key of another table. My data sources are csv files (and all of the csv files have addresses as a common field) so I usually do tFileinputdelimited ------------------------ tmap-------------------------postgresqloutput. Ideally I would like to make a foreign key referring to the addresses field in each table.
I would greatly appreciate any assistance!!
Thanks,
CM

Re: Create a foreign key

Anonymous — Fri, 27 Jan 2017 19:24:42 GMT

Can anyone help me? Any assistance would be appreciated. Please tell me how to make a foreign key.

Re: Create a foreign key

vapukov — Sun, 29 Jan 2017 20:24:17 GMT

Yes, You can use sequence (or any other function) as Primary Key, and as Foreign key
SO, main - question - What is Your problem?

Talend - is NOT database administration or development tools (unfortunately - but ...) :-)
It not cover many aspect of database development/administering.
You can create Key in Table using SQLRow (for Your type of database) - and run command for ALTER TABLE