Home
Kimball Group Home
Search
Register
Log inMulti-tenant design for Data Warehouse
Page 1 of 1
Multi-tenant design for Data Warehouse
andriy.zabavskyy Tue Nov 20, 2012 8:58 am
Could anyone advise resources about multi-tenant design for Data Warehouse?
Is it worth to create tenant dimension?
Thanks
Is it worth to create tenant dimension?
Thanks
andriy.zabavskyy- Posts : 18
Join date : 2011-09-12
Re: Multi-tenant design for Data Warehouse
andriy.zabavskyy Wed Nov 21, 2012 4:39 am
Actually I see 2 approaches:
1) Create Tenant Dimension which would play a role of outtrigger: every other dimension table would have a tenantID key which would refer to it. All queries should be filtered by tenant.
2) Create separate schema for each tenant
Does anyone have experience which these approaches?
Thanks
1) Create Tenant Dimension which would play a role of outtrigger: every other dimension table would have a tenantID key which would refer to it. All queries should be filtered by tenant.
2) Create separate schema for each tenant
Does anyone have experience which these approaches?
Thanks
andriy.zabavskyy- Posts : 18
Join date : 2011-09-12
Similar topics» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» Multi - tenant or SaaS Warehouse architecture
» Multi-tenant architecture
» Design a snapshot Fact table in data mart from compliance-enable fact table in enterprise data warehouse
» Is it a best practice that Data warehouse follows the source system data type?
» Multi - tenant or SaaS Warehouse architecture
» Multi-tenant architecture
» Design a snapshot Fact table in data mart from compliance-enable fact table in enterprise data warehouse
» Is it a best practice that Data warehouse follows the source system data type?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum