6/17/2023 0 Comments Toad for sql server source controlTo practice creating a star schema data model from scratch, we first reviewed some data model concepts and attested that the SQL Server Management Studio (SSMS) has the capacity for data modeling. Due to lack of experience on data modeling, the team wants to know how to manipulate Microsoft tools to create and maintain a star schema data model. After team members have pored over Kimball’s other book, the team is ready to build a DW/BI system. Furthermore, facts and dimensions have been identified and documented. The team has taken Kimball’s advice and considered using the star schema as the data warehouse schema. To apply this principle, a software development team wants to create a data warehouse with the Microsoft toolset. One technology principle recommended by the Open Group Architecture Framework (TOGAF) is to control technical diversity.
0 Comments
Leave a Reply. |