Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Business Intelligence Applications

Reading Siebel S_AUDIT_ITEM

Question

Views

Comments

Tata Consultancy Rank 1 - Community Starter

Mar 1, 2018 1:11PM in Oracle Business Intelligence Applications

Hi ,

We have requirement to read SIEBEL. S_AUDIT_ITEM table to capture the history of few attributes and load it into DWH.

Informatica mappings issue queries with conditions like BUSCOMP_NAME='<>' and AUDIT_LOG like '%TABLE_COLUMN%' and OPEARTION_DT in between some dates.

S_AUIDT_ITEM table currently has 27million records and we have index defined on BUSCOMP_NAME column only.

The data retrieval takes more time for Informatica reader and hence delays the entire DAC load.

Request to provide any performance suggestions or reference to any documentation for this issue.