topic Re: Inserting into multiple tables in Talend Studio

Inserting into multiple tables

Anonymous — Sat, 16 Nov 2024 13:43:15 GMT

Hi,
We are reading delimited file which contains around 50 attributes in a row. We need to insert this into multiple tables. I have a map in which all the data is loaded. We are using oracle database and each table has primary key which is an oracle sequence. In some tables there are no relation and i can use additional coloumn in advanced settings to use the sequences as primary key. But there are few tables where PK of one table is used as FK in another. I am not sure here how to use Oracle sequence. I know that we can use builtin sequece which comes with TOS, but we can't go with that approach. Is there a way to solve this problem. Any pointers would also be a great help. Thanks in Advance.
Regards,
Arul.

Re: Inserting into multiple tables

Anonymous — Mon, 26 Oct 2009 03:26:44 GMT

Hello Arul
Here is a 1488 shows you how to use oracle sequence on TOS.
Best regards

shong

Re: Inserting into multiple tables

Anonymous — Tue, 27 Oct 2009 13:44:51 GMT

Thanks for Quick response Shong. I am able to use Oracle Sequence. The problem i am facing is after inserting the first row, i need to fetch the generated oracle sequence and use it to insert into second table. I am looking for inputs to do this. Thanks in advance.
Regards,
Arul.

Re: Inserting into multiple tables

Anonymous — Fri, 06 Nov 2009 23:08:30 GMT

I too am having this issue. Is there a solution?
Regarding,
emo

Re: Inserting into multiple tables

_AnonymousUser — Tue, 05 Oct 2010 08:50:37 GMT

So no solution for using Oracle's nextval from PK in one table as FK in another table?