Forum Discussion
Sample AdventureWorksDW with stored procedures for populating fact and dims
Hello,
I am looking for sample SQL database that will provide sample scripts that will have tables and stored procedures that will show how populating fact and dims should look like for any type of SCD. I have downloaded few AdventureWorksDW versions but I cannot see any example procedures for populating tables. Could someone point me in the right direction please?
soldes AdventureWorks is old, better use the newer example databases from
And both load the DWH using SSIS poackage = "SQL Server Integration Services" as ETL tool, not via plain T-SQL.
- olafhelper thanks for sharing this, however due to business requirements this needs to currently stay as T-SQL...
- Sure you can do it in plain T-SQL (I do it sometimes as well), but AdventureWorks/WorldWideImport don't, so you can't use it as an example for learning.
