Dimension Table and Fact Table in SQL Oracle| What are Dimension & Fact Tables in Oracle SQL|
Dimension Table and Fact Table in SQL Oracle| What are Dimension & Fact Tables in Oracle SQL|
Here I explained how data store in database and in data warehouse like Dimension table and in fact table formats. Types of Dimension Tables and Types of Fact Tables and SCD Types .
Also explained primary key and foreign key