Projeto ETL em SQL Server | Parte 2 - Modelagem Dimensional, Tabela Fato e Foreign Keys

SQL Server ETL Project | Part 2 - Dimensional Modeling, Fact Table, and Foreign Keys In this second part of the SQL Server ETL project, we continue building the Data Warehouse. After data processing and standardization, we perform dimensional modeling using the star schema, create the dimension tables and the fact table, load the data, and implement foreign keys to ensure the referential integrity of the environment. What you will see in this video: Dimensional Modeling Concepts Star Schema Structure Creation of dimension tables: DIM_CLIENTE, DIM_PRODUTO, DIM_VENDEDOR, DIM_REGIAO, DIM_DATA Creation of the fact table (FATO_VENDA) Loading dimensions using DISTINCT Loading the fact table using JOINs Implementation of Foreign Keys