Multi-tenant design for Data Warehouse

View previous topic View next topic Go down

Multi-tenant design for Data Warehouse

Post  andriy.zabavskyy on 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

andriy.zabavskyy

Posts : 18
Join date : 2011-09-12

View user profile

Back to top Go down

Re: Multi-tenant design for Data Warehouse

Post  andriy.zabavskyy on 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

andriy.zabavskyy

Posts : 18
Join date : 2011-09-12

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum