Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert same sequence in multiple tables in ODI

3012621May 5 2017 — edited May 10 2017

I have a flat file which is used to populate data in a table A. There is another Table B which has one column same as that of A and is a sequence.

So how do i insert that same sequence number simultaneously in both table A and table B.

I cannot commit data into Table A till the whole flow is completed. Hence the column which I need to access is present in the I$ table. But i am unable to access the column.

Any suggestions on this?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2017
Added on May 5 2017
#business-intelligence-applications, #data-integrator, #system-management-and-integration
9 comments
599 views