Course Title: Data Warehousing (CS614)

 

Lecture No. 15:

 
 

Introduction

Step-3: Additive vs. Non-Additive facts

Step-3: Classification of Aggregation Functions

Step-3: A Fact-less Fact Table

Step-4: Handling Multi-valued Dimensions?

Step-4: OLTP & Slowly Changing Dimensions

Step-4: Creating a Current Value Field

Step-4: Pros and Cons of Handling

Step-4: Junk Dimension

      

     

     Introduction

·         Additive vs. Non-Additive facts

·         Classification of Aggregation Functions

·         Not recording Facts

·         A Fact-less Fact Table

·         OLTP & Slowly Changing Dimensions

 

 

                       NEXT