Retrieve autoincremented primary key Id for each inserted row and use it in second table

[Anonymous]

Hi ,

Currently I have input source oracle data which I try to save it to table_A which is PostgreSQL database and this table has auto-incremented primary key.

We have below 2 questions:

1] Once we insert this row in Table_A how i can get auto-incremented value and save it Table_B.

2] Is there any feature/components available using which we can compare source data to destination data and decide if it is new data to be inserted or existing data which we need to update...

Thanks,

[Anonymous]

Hi,

I start in talend and I work on a practical project.
I have a problem with inserting all my rows into my table.
The output of the first tmap returns all the rows, against the output of the second tmap returns single row.
Could you help me please?

5.PNG
6.PNG
7.PNG
8.PNG

[Anonymous]

Thanks after read your valuable inputs I have get the PK from table.

[Anonymous]

Thanks, It's useful for me.

--

Ashok Parmar