Posts

Bitmap Join Indexes

Bitmap Index Overview

SCD Type 2 error: ODI-1228:ORA-01747: invalid user.table.column, table.column, or column specification

Oracle Job Schedulers examples

Get a list of MViews depending on table using DBMS_MVIEW.GET_MV_DEPENDENCIES

B-Tree Index

World of ETL Tools Available ... sooooooomany etl tools.....

HOW TO Kill The Running Job & session in Oracle

What is Fact ? and Types of Fact?

Types Dimensions in Dimensional Modeling

Difference between Datamart and Data Warehouse

What is Factless Fact table? When we will use this?

Dimensional Hierarchy example

Start Schema Data Warehouse Concepts

Snowflake Schema Data Warehouse Concepts

Galaxy Schema Data Warehouse Concepts

Differences between Star Schema and Snowflake Schema Data Warehouse Concepts

SCD - Slowly Changing Dimention - Type 1, Type -2 , Type -3 Data Warehouse Concepts

Top-down versus bottom-up design methodologies in Datawarehousing

Physical Data Model - Design Step -3

Logical Data Model - Design Step -2

Conceptual Data Model - Design Step 1

PLSQL Interview Questions

SQL * LOADER

LINUX and Shell Scripting