Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning,
I am trying to generate an tELTOracleOutput which needs to generate a sequence number for a oracle table. The sequence has already been created in Oracle.
I have tried multiple options and cannot seem to get it to work.
context.SequenceNumber
Numeric.sequence("s1",1,1)
STK_SLF_CNT_TCKR_FS_v1_SEQ.NEXTVAL
I have searched for this and cannot seem to find a solution.
Kind Regards,
Shaf
Hello,
I'm not sure, but what happens if you put the component "tOracleRow" and add this query:
"select nextval('" + context.sequenceNumber + "')"
Or maybe
"select nextval('your_schema.STK_SLF_CNT_TCKR_FS_v1_SEQ')"
EDIT : tOracleRow, and not tOracleInput
@eost thank you for your response.
Due to using ELT component, ETL component is not compatible.
The reason I need the sequence is so that I can perform SCD against the new data that gets inserted from the initial job.
I have used the SCD component without surrogate key but that does not impact the data when there is a change in "Type 2".
I have tried multiple ways of writing the sequence in to the ELT Oracle output table and cannot seem to surpass this stage.
Hi
Can someone please help.
Thank you.