Wednesday, February 25, 2015

Reference Dimensions - SSAS 12



Refer Source: Reference Dimensions - SSAS 12

note:

i.In the star schema , if  there is a snowflake schema structure has to be clubed together , the reference dimension
come into picture.
example: the fact table is connected to the Customer table
but geography table is not and it has a link to customer table.

i. Materialized if checked it's created in the physical storage.



No comments:

Post a Comment