Execute Full Load in BIAPPS 11.1.1.7.1
Blog
  • Topics
  • Industries
  • Partners

Explore

Topics

Industries

Partners

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

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’;

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