Implement a Serving Layer with a Star Schema – The Storage of Data-1Implement a Serving Layer with a Star Schema – The Storage of Data-1
FIGURE 4.35 Serving layer using star schema distribution types FIGURE 4.36 Serving layer using star schema integration dataset COPY INTO [brainwaves].[DimMODE]FROM ‘https://.blob.core.windows.net/brainjammer/Tables/MODE.csv’ WITH ( FILE_TYPE=’CSV’,FIRSTROW = 2)GO COPY INTO [brainwaves].[DimSCENARIO] [...]