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!

Create temporary index

mcoeneOct 9 2019 — edited Oct 16 2019

Hi all,

I was looking into creating a (temporary) index on the staging table I am reading from, when performing an update.

The update in TGT table happens for the records where SRC.TUPLE_ID = TGT.TUPLE_ID

I would like to create an index on SRC.TUPLE_ID but I have not found a way to fetch the column name in the source table using odiRef

I also encountered the possibility to "Create Temporary Index" and I tried turning that on, but I cannot see any code for this in the simulation of the mapping

Anyone who can offer me some insight on all of this?

Added on Oct 9 2019

#business-intelligence-applications, #data-integrator, #system-management-and-integration

7 comments

2,233 views