Datawarehouse
Budget: ₹600 – ₹1,500 INR
I want a clean, repeatable SSIS package that extracts data from the AdventureWorks OLTP database and populates a small star-schema warehouse. The package must:
• Create and load DimCustomer and DimDate with surrogate keys and all attributes ready for analysis.
• Build an accumulating snapshot fact table, AccumulatingFactOrderPerformance, capturing each order’s key milestones (order, due, ship) together with the relevant quantities.
• Run both an initial full load and an incremental load that can be scheduled.
• Come with SQL scripts for building the warehouse objects plus concise documentation showing package flow, configurations, and how to extend the model.
Please keep the control flow modular, use best practices for look-ups and SCD handling, and parameterise connections so I can point the package to different environments without edits. I’ll test by running the full load, then pushing a small set of new orders and verifying that only deltas reach the warehouse.
• Create and load DimCustomer and DimDate with surrogate keys and all attributes ready for analysis.
• Build an accumulating snapshot fact table, AccumulatingFactOrderPerformance, capturing each order’s key milestones (order, due, ship) together with the relevant quantities.
• Run both an initial full load and an incremental load that can be scheduled.
• Come with SQL scripts for building the warehouse objects plus concise documentation showing package flow, configurations, and how to extend the model.
Please keep the control flow modular, use best practices for look-ups and SCD handling, and parameterise connections so I can point the package to different environments without edits. I’ll test by running the full load, then pushing a small set of new orders and verifying that only deltas reach the warehouse.