Data360 Analyze

Hi,

I want to insert incoming records from transformation node to "TABLE_A" using DB Store node. But before I insert it to "TABLE_A", I want to add the database sequence used by "TABLE_A" as ID.

That would be something like this:

Incoming
column A	column B
A1	B1
A2	B2
A3	B3

select sequence_name.nextval as ID from dual;

with sequence
ID	column A	column B
6	A1	B1
7	A2	B2
8	A3	B3

Is this feasible or are there other ways of doing it?

------------------------------
Dhinmar James Cayog
Knowledge Community Shared Account
------------------------------

If your organization's coding standards allow for it, then the easiest thing to do is to set the column default value to the sequence.NEXTVAL you want to use, and ignore the entire column in the insert statement. This works with JDBC store, I think it should work with DB Store.

------------------------------
Peter Sykes
Vontobel Holding AG
ZUERICH
------------------------------

Thank you Peter.

------------------------------
Dhinmar James Cayog
Knowledge Community Shared Account
------------------------------

Original Message:
Sent: 03-26-2023 16:49
From: Peter Sykes
Subject: Use Oracle Sequence and add to incoming data

If your organization's coding standards allow for it, then the easiest thing to do is to set the column default value to the sequence.NEXTVAL you want to use, and ignore the entire column in the insert statement. This works with JDBC store, I think it should work with DB Store.

------------------------------
Peter Sykes
Vontobel Holding AG
ZUERICH
------------------------------