In the part1 in this series, we showed how you can identify the top running maps in a load plan. In this blog, we list certain parameter/settings at...
In the part1 in this series, we showed how you can identify the top running maps in a load plan. In this blog, we list certain parameter/settings at ODI/Database/Network level that can influence the overall load plan timings. ODI Settings 1) Check the number of parallel sessions configured against the ODI agent. Recommendation is to have NOT more than 5 ODI sessions configured to run in parallel. If your server is not sized up properly, this may have to be reduced further....
In the part1 in this series, we showed how you can identify the top running maps in a load plan. In this blog, we list certain parameter/settings at ODI/Database/Network level that can influence the...
At times, the source system for BIAPPS might have additional tables that you want to extract the data from and get into BIAPPS. This blog specifies the steps on...
At times, the source system for BIAPPS might have additional tables that you want to extract the data from and get into BIAPPS. This blog specifies the steps on how to import a source table that is there in Source system but not present in the BIAPPS ODI repository. It is assumed that the user has already registered the Source system before attempting any of the steps in this document. Please refer to the BIAPPS documentation incase you need help with the Source Registration....
At times, the source system for BIAPPS might have additional tables that you want to extract the data from and get into BIAPPS. This blog specifies the steps on how to import a source table that...
In OBIA, the normal process would be to use OBIACM to generate the load plan then schedule it. However at times, customers report issues with regards to load...
In OBIA, the normal process would be to use OBIACM to generate the load plan then schedule it. However at times, customers report issues with regards to load plan schedules. This blog explains why such things are likely to happen and how to resolve them Symptoms Observed: Duplicate Load plan schedules, so the same load plan running multiple times. However only one schedule visible in OBIACM Schedule not visible in OBIACM but load plan running daily as if it were scheduled...
In OBIA, the normal process would be to use OBIACM to generate the load plan then schedule it. However at times, customers report issues with regards to load plan schedules. This blog explains...
Author: Patrick Block ODI E-LT and Work Tables (I$ and C$) In BI Applications 11.1.1.7.1, the ETL is performed by ODI, which transforms the data by issuing SQLs...
Author: Patrick Block ODI E-LT and Work Tables (I$ and C$) In BI Applications 11.1.1.7.1, the ETL is performed by ODI, which transforms the data by issuing SQLs to both the source and DW DBMS, otherwise known as E-LT. During this E-LT processing ODI creates intermediate or work tables in the BI Application Data Warehouse schema, these are tables prefixed with I$ and C$. When a scenario successfully completes, it will automatically delete these tables, as they're transitory...
Author: Patrick Block ODI E-LT and Work Tables (I$ and C$) In BI Applications 11.1.1.7.1, the ETL is performed by ODI, which transforms the data by issuing SQLs to both the source and DW...
Author : Jayant Mahto NOTE: This support is only available for Oracle database. When a LP is executed by an ODI agent then it creates ODI sessions for the...
Author : Jayant Mahto NOTE: This support is only available for Oracle database. When a LP is executed by an ODI agent then it creates ODI sessions for the scenario steps and sends appropriate SQL to the DB for execution, which in turn creates DB sessions. For long running jobs (or when there is a suspicion that some sessions are hanging in ODI) we need to correlate ODI sessions and the corresponding DB sessions. This is achieved by examining the content of the ACTION column...
Author : Jayant Mahto NOTE: This support is only available for Oracle database. When a LP is executed by an ODI agent then it creates ODI sessions for the scenario steps and sends appropriate SQL to...