Data Warehouse [SSAS] Questions: Notes: How can you optimize reading from a Cube? In order to optimize reading from a cube, you physical normalize the dimensions via attribute hierarchies. It is also a good idea to create Partitions in the data storage files of the cube. By creating partitions the server can perform parallel processing […]
Data Warehouse [SSAS] Questions: Notes: What is SSAS? SSAS stands for SQL Server Analysis Services. It allows us to take data from our data warehouse and analyze it for Business Intelligence. What are Attribute Hierarchies? In relational tables, there are columns. In Cube Dimensions, columns are known as Attribute Hierarchies. What are Members of Attribute […]
I hope everyone had a wonderful July 4th. l want to end this week with one nice piece of information on the naming conventions used in SSIS. There are different conventions used by different organizations but the ones below seems to be standard across lot of organizations. Using a standard naming convention in your work […]
The independence holiday is here. I have half day off today so l just want to spend some time and write a short post on optimizing queries. Have you asked yourself this question, How do I optimize queries? Well, I think I have asked myself this question almost on daily basis because am obsessed with […]