One Star

Talend OS: How to route the resultset of tOracleRow to an ID column

Hello,
Your help is very much appreciated on the following. I have a query that captures the next sequence number in an Oracle Table (e.g. query "SELECT ID_SEQ.NEXTVAL FROM DUAL" using tOracleRow component) which should be retained (say using 'Propagate QUERY's recordset in Advanced Settings of tOracleRow) to use this sequence and populate some other tables that would satisfy referential integrity constraint . The problem is Edit Schema in basic settings (tOracleRow) doesn't show any output that would allow addition of a recordset object - and there is no recordset object available to propage QUERY's result in advanced settings. How can this be resolved?
Thanks,
Krishna
2 REPLIES
Seventeen Stars

Re: Talend OS: How to route the resultset of tOracleRow to an ID column

You have to map the resultset to an schema column of type Object. After that put a tParseRecordSet into the flow and for the ID column write the result set column name as String "ID". It is recommended to give your sequence value an alias:
"SELECT ID_SEQ.NEXTVAL as ID FROM DUAL"
This way you fill the column which dedicated for your ID with the value from your sequence.
One Star

Re: Talend OS: How to route the resultset of tOracleRow to an ID column

I ended up using Numeric.Sequence("SequenceName", 1, 1). It works great.