etl - talend data insertion with auto increment keys

Question

I am using talend studio free version. I have an excel with 2 sheets "System" and "Part" table data. I want to insert the data into redshift tables system and part respectively. First I want to check if given system is already present in redshift table, if yes, retrieve its system id, if not then add it with new system id. The same goes for part data, if part already present, get the part id, if not then add the record with new id.

Once this is done, the system id(existing/new) along with part id(existing/new) should be added to a map table system_to_part which has columns system_id and part_id.

The tables in redshift are created with ids as auto increment and upon adding rows I see ids generated. But how can I take the ids in talend and insert into a new table(system_to_part)?

question from:https://stackoverflow.com/questions/65517637/talend-data-insertion-with-auto-increment-keys

Answer 1

Waitting for answers