Create a DW incl. starschema

82 Views Asked by Johan EK. At 10 April 2025 at 18:18

I have 2 .BAK files and I want from that to create a small DW that I build in the new database including a star schema.

I have tried to restore the 2 bak files inside MSSM, and then it created two database.

Im confused if I have done it right or what next steps is it?

There are 1 best solutions below

XAMT On 02 April 2020 at 16:00

No, It's just two versions of a single database.

For the DW Star Schema, you should have one fact table in the centre of the star and a number of associated dimension tables.