Dataware house schema desgin RRS feed

  • Question

  • the datawarehouse star schema design, how to handle the foreign key issues ? as datawarehouse doesn't have foreign key . ??

    what's the best way to design and draw the star schema?

    Friday, August 30, 2019 9:38 AM

All replies

  • Hi Sakurai_db.

    Data Warehousing (link) in Azure has a few architectural and design considerations depending on the solution objective but if you are looking specifically for table design, the Designing Tables document is specific to your inquiry and covers the various aspects of creating a Star Schema.

    Please let us know if you have additional questions.



    Monday, September 2, 2019 8:25 PM