OBIA 11g: EMPLOYEEDIMENSION_JOBINFORMATION Session in ODI is Not Running as Expected
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 and later
Information in this document applies to any platform.
Implementing OBIA with HR Analytics and using Peoplesoft as a source.
You have created a load plan in the BIACM (HCM Load) and monitoring it in ODI on daily basis.
As part of a daily incremental load, the session, completed within seconds and sometimes its taking a long time and causing a delay in the data load.
Session Name: SDE_PSFT_91_ADAPTOR_SDE_PSFT_EMPLOYEEDIMENSION_JOBINFORMATION
The session took 5541 seconds to complete on 21-Sep-2015 and 67 seconds on 23-Sep-2015.
Why are there fluctuations? How can you tune this query so that there will be no fluctuations in this session?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms