DWH Layers
Page 1 of 1
DWH Layers
I am confused of different layers in DWH. It would be helpful if anyone explains the different layers in DWH (Staging/Foundation/Presentation).
Thanks in advance.
Thanks in advance.
Guest- Guest
Re: DWH Layers
My opinion:
Staging: the area where you import your source data to and then transform it into the format you will load into your dimensional model i.e. the 'T' part of ETL
Foundation: not a term I use myself but I presume this means the actual dimensional model itself
Presentation: the area that your report writers are exposed to. This could be a set of DB views over the Foundation layer or the metadata layer in your BI tool (OBIEE, Bus Objects, SSRS, etc).
Hope this helps
Staging: the area where you import your source data to and then transform it into the format you will load into your dimensional model i.e. the 'T' part of ETL
Foundation: not a term I use myself but I presume this means the actual dimensional model itself
Presentation: the area that your report writers are exposed to. This could be a set of DB views over the Foundation layer or the metadata layer in your BI tool (OBIEE, Bus Objects, SSRS, etc).
Hope this helps
nick_white- Posts : 364
Join date : 2014-01-06
Location : London
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum