Source: dzone.com
How to Design Data MartsCategory: Business, Database, Data
Data marts are the business user interface of your data warehouse.
This article will give some best practice tips for designing useful data marts for your business teams.
So you can create some end-of-month or maybe end-of-week structures in your data marts.
To design the common structures you can group them in two categories: You can prevent all user to query your common structures and create database roles for each of the business teams defining each team their own policy with their database role.
At this point, calculated data can be generated for your data marts in daily, weekly, or monthly basis as required.
This article will give some best practice tips for designing useful data marts for your business teams.
So you can create some end-of-month or maybe end-of-week structures in your data marts.
To design the common structures you can group them in two categories: You can prevent all user to query your common structures and create database roles for each of the business teams defining each team their own policy with their database role.
At this point, calculated data can be generated for your data marts in daily, weekly, or monthly basis as required.
Related Articles
Community Partners
DevOps Careers