Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Reading Siebel S_AUDIT_ITEM
Tata Consultancy
Rank 1 - Community Starter
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.
0