Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Saturday, 24 August 2013


By on 08:47:00

Execution Plan 

An execution plan is the process of entire work carries over in DAC, which enables to organize, schedule and execute the ETL process.

An execution plan is the collection of subject areas give in DAC and its group of tasks.

Execution plan is based on subject areas and business requirements, according to the data warehouse need to be loaded. A process of data transformation includes subject areas and schedule time it depends on the type of loading the data whether full load or incremental loads.

Architecture of Execution Plans

Types of Execution Plans:
1.      Single Source Execution Plan
2.      Multi-Source Execution Plan

Single Source Execution Plan

A single-source execution plan extracts data from a single request of a single source system container, such as Oracle Ebiz or People soft or others.

Multi-Source Execution Plan

A multi – source execution plan extracts data from a single instance of a single source system container or multi source system containers as well as multi instance of a multiple source system containers.

Types of Multi – source Execution Plan

1.      Heterogeneous
 Heterogeneous execution plan which process the instance from various source systems in different time of scheduling the execution plan one after other. Even it extracts the data from single source system with different time of execution of subject areas from different place of locations.

2.    Homogeneous
 Homogeneous execution plan which process the instance from single source system in a particular times of schedule of the tasks as one after the other. It extracts the data from single source system with multiple instances at different location and time.

Extract and Load (Single)
It is the normal and simple plan of extraction and load into the target tables of data warehouse.
Having single instance of load and extract data from single source and move the data into staging, then load to Data warehouse.

Truncate process in DAC for single load and single extract condition, which truncate the tables, indexes and recreate the indexes and it will analyze the table.

Single Load and Multiple Extract

Multiple extract and single load is the process of extracting the data from single or various source systems at various time and location using the single staging and single data warehouse.
Here we have the heterogeneous and homogeneous multi source extraction, transformation and loading process will carry out.

Having one or more similar source system at different location and time loads to single end data warehouse.


            Having one or more different data source system from different location and time loads data into the end data warehouse.

Truncate process in DAC for single load and multiple extract condition, which truncate the tables, indexes and recreate the indexes and it, will analyze the table. It will analysis the data source systems schedule timings and assign the priority to drop indices and analyze the tables.
Analyze Truncate Tables Only:

Purpose of “Analyze Truncate tables only”, when we running the task for a subject areas  we extract and load as “full load” as well as “Incremental Load”  it indicates the tables associated with the execution plans will be analyzed and run the tasks according to the refresh dates.

Drop/Create Indices:

Indices mean a combination of one or more indexes. It sounds plural of index.
An Index is the optional of created tables, purpose to access the data as much as quick and easy.
By creating one or more columns of the table can have ability to gain some distributed columns or set of rows of data from the original table. It is used to reduce the system heap space and disk space.Flexible in fetching the rows very speedy.

            Indexes of the tables associated with the execution plan will be dropped and re-created. When we using full load all the indexes tables will be dropped and re-created. When we using incremental load the tables where truncated will be dropped and recreated the indexes.


It is the task which is used to evaluate and analyze in the data warehouse after the process of truncation, drop indexes, informatica mapping and then recreation of indexes.

Full Load Always:

It indicates the ETL process to execute the data as a “full load” process.

Refresh Dates:

Refresh dates refer to the date of the last ETL process i.e., the last time data was extracted or loaded from tables in given database. DAC uses the refresh dates to determine whether to run the incremental load commands or to run full load commands and whether to truncate the target tables.

Micro ETL Execution

Micro ETL execution plans are ETL processes that you schedule at very regular intervals, such as hourly or half-hourly. They usually handle small subject areas or subsets of larger subject areas. DAC tracks refresh dates for tables in micro ETL execution plans separately from other execution plans and uses these refresh dates in the change capture process.


  1. Hi Kashif.. I have a question. Can we don specific date range load in DAC. Like from 1995 Jan1st to 2013 Dec31st ?If yes where can i set the date parameters. If no why can we set?Please let me know ASAP. Thanks


Blog Archive


1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA (1) OBIA (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)