Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Multi-tenant design for Data Warehouse

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

Multi-tenant design for Data Warehouse Empty Multi-tenant design for Data Warehouse

Post  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

andriy.zabavskyy

Posts : 18
Join date : 2011-09-12

Back to top Go down

Multi-tenant design for Data Warehouse Empty Re: Multi-tenant design for Data Warehouse

Post  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

andriy.zabavskyy

Posts : 18
Join date : 2011-09-12

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

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