Oracle

Steps to Execute Full Load in BIAPPS 11.1.1.7.1

shutterstock_286959035

In BIAPPS whenever a ODI package is executed it reads  W_ETL_LOAD_DATES table to verify if a record exists with that package name. If record found package is executed in incremental mode else Full load mode. In incremental mode package will update the last_executed_date of existing record in W_ETL_LOAD_DATES table and in Full load mode package will insert new record.

To perform a full load we need to execute Reset Data warehouse scenario through BIACM, This scenario resets the data warehouse by truncating the W_ETL_LOAD_DATES table. This ensures that packages in subsequent load will not find a record in W_ETL_LOAD_DATES table and truncate all target tables and do a fresh full load.

We can also achieve this by truncating table W_ETL_LOAD_DATES manually in Data Ware House database.

TRUNCATE TABLE W_ETL_LOAD_DATES;

Steps to execute Reset Data warehouse scenario through BIACM:

Login to BIACM http://<hostname>:9704/biacm

Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

1

Click on manage load plans

2

Click on actions

3

Click on Execute Reset Data Warehouse Scenario

4

Select context, logical agent, work repository and log level

5

After executing this scenario, check in Data Ware House schema. Table W_ETL_LOAD_DATES should be truncated.

Then execute load plan, it will truncate and full load all tables as there are no records in W_ETL_LOAD_DATES table.

To Full load particular table, we need to delete a record from W_ETL_LOAD_DATES associated to package which populates this table.

Ex:

DELETE FROM TEST_DW.W_ETL_LOAD_DATES where PACKAGE_NAME = ‘PLP_PLP_APSNAPSHOTINVOICEAGING’;

About the Author

10 years of experience doing analysis, design, development and implementation of Oracle Business Intelligence applications and ETL solutions using Informatica, DAC, ODI. Worked extensively on Oracle BIAPPS Implementations, SQL querying and Stored Procedures using PL/SQL. Worked on Functional Areas - HR, Finance, Service and Marketing Analytics, Procurement and Spend Analytics, Supply Chain and Order Management Analytics, Enterprise Healthcare Analytics (EHA) and OHADI (Oracle Healthcare Analytics Data Integration)

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up
Categories