[resolved] Store value of Oracle Sequence for use in data flow
Hi. I have a spreadsheet with data that will go to several oracle database tables. I must grab the sequence number from oracle and use the same sequence number in each of the tables. So far I have been successful using a tOracleInput to get the next sequence number, but only once for the entire run. I need to grab a new sequence number for each row. Which component do I use?
I have tried using tOracleRow with the propagate option, but it grabs it as a resultset and I don't know how to cast that to an int. I have used the tOracleOutput Additional Rows feature, which inserts the new sequence into the table just fine but doesn't put it into the data flow.
I am desperate for some help as this project is due by Thanksgiving!
Thanks,
Eileen
Hi Shong, I have a requirement where in I have input from flat file, it needs to be loaded to say 10 tables. There is 1 column which needs to be unique but generated through Talend as a sequence ( as my DB is not Oracle but Amazon redshift). This column value must be fetched from the last max value of this column and then incremented by 1. Also, same column value needs to be inserted to multiple tables. e.g. 1 row inserted into 10 tables with this column value being the same in all 10 tables. Can you please help me out as urgent. Thanks Atul
Hi Atul/ Shong -
Any update on the above question -
does talend have any reusable sequence generator like in Informatica.
Even I have the above scenario - and I have used tmap to generate seq.id's. but since its not reusable - all the targets are getting different sequence number.
Pls do lmk as soon as possible.
Thanks in advance
Rose
