Choose currency


Incremental Loading in Data Warehouse

In almost all data warehousing scenario, we extract data from one or more source systems and keep storing them in the data warehouse for future analysis. The source systems are generally OLTP systems which store everyday transactional data. Now when it comes to loading these transactional data to data warehouse, we have 2 ways […]

Incremental data load in Fact tables of DW env

Here are few methods and issues of loading data incrementally in Fact tables of a data warehouse.
Generally speaking, incremental loading for Fact tables is relatively easier as, unlike dimension tables, here you do not need to perform any look-up on your target table to find out if the source record already exists […]

Roles involved in a BI Data Warehouse Project

To develop or deploy a BI solution for your organizations, you need to have the right people involved in the time time. Here are typical roles involved in a BI data warehouse project.

Project Sponsor
Project Manager
Functional Analyst
BI Architect
ETL Developers

The job description and responsibilities are listed in this table:

Job Role

Project Sponsor
The project sponsor is normally an […]

Incremental ETL process in BI Apps

The data warehouse needs to be refreshed periodically to make sure that the data warehouse have the up to date information.  The Incremental Load is the regular ETL process running everyday.  The frequency can vary, but it is commonly seen as nightly job.  To ensure that the incremental ETL job can be finished within […]

Overview of OBIEE DAC

DAC stands for Data Warehouse Application Console.  It is an essential component of Oracle BI application architecture.

DAC serves the following purposes:

1. DAC is a metadata driven administration and deployment tool for ETL and data warehouse objects


2. Used by warehouse developers and ETL Administrator


3. Application Configuration


Manages metadata-driven task dependencies and relationships
Allows creating custom ETL execution […]

How to model the OBIEE RPD


OBIEE Modelling in an existing EDW Subject Area (Bottom-Up) based upon existing reports.

The following steps helps to do modelling .


1. Before you start:1.1. Talk to user and understand business behind report1.2. Talk to business analyst and get example report, SQLs, existing ER diagrams

1.3. Understand grain, dimensionality of subject area

1.4. Check SQLs, data quality and […]

How to create nested sub folders in OBIEE 11G Answers

There was limitation of 2 level folder nesting allowed in env using below or equal to OBIEE

This limitation has been enhanced in OBIEE with excellent featueres. However in order to next the presentation folder’s, you should log in to OBIEE RPD and locate presentation layer. Then select presentation table the one you […]