Data-ware Housing

Performance of DB columns of different data types are as follow
numeric > char > varchar > date > blob > clob

DW FACT Table + DIMENSION Tables
STAR Schema | SNOW FLAKE Schema | GALAXY Schema

Dimension loading - Type1 (No History Stored)| Type2 (Store History)| Type3 (Store Partial History)

Dimension Types - Slow Changing Dimension
                                Fast/Rapid/Monster Dimension
                                Confirmed Dimension
                                Role Play Dimension
                                Bridge Dimension
                                De-generate Dimension
                                Audit Dimension
                                Identity Dimension