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!

Dynamic names for I$ ,C$ and E$ tables in ODI

394099Jan 7 2010 — edited Jan 13 2010
Dear ODI Team,

We have a requirement where we are loading header data and then line data in our Package.ODI internally creates work tables to load data into target tables.If multiple sessions of the same interface is executed at the same time the I$table of the previous session affects the I$ table of the next session.Hence if session1 has completed loading then it is at the stage of dropping the I$ table.Hence the second session is erroring out.Kindly let me know if there is an option to create these work table names dynamically for each session


Thanks ,
Anand
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2010
Added on Jan 7 2010
#business-intelligence-applications, #data-integrator, #system-management-and-integration
11 comments
7,074 views