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
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
