From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

Inserting into multiple tables

Highlighted
One Star

Inserting into multiple tables

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.
Highlighted
Community Manager

Re: Inserting into multiple tables

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

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Highlighted
One Star

Re: Inserting into multiple tables

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.
Highlighted
One Star
One Star

Re: Inserting into multiple tables

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

Re: Inserting into multiple tables

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog