Presentation Layer
3 posters
Page 1 of 1
Presentation Layer
Is it typical to have two separate layers in data warehousing environments? One is for ETL layer and the other is for presentation(access to business users) and reporting needs. The data in the two schemas would be the same and want to know if this the best practice that folks implement all the time?
rajeshwarr59- Posts : 21
Join date : 2015-06-26
Re: Presentation Layer
I've never done it that way. ETL has a batch window to update the "warehouse" tables. I do have a test environment that closely mirrors production though.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Presentation Layer
From a software layer standpoint, yes, it is typical to have ETL and presentation layers. From a data layer point of view, you typically have a landing/staging area that ETL uses, and a dimensional data warehouse if you are following Kimball's architecture. The presentation software sits on top of the dimensional warehouse. So, you have one primary data storage area that is loaded by ETL and accessed by end-users. If you are implementing a store and publish architecture (Inmon, Lindstedt) the data warehouse is separate and distinct from data marts used to support end-user queries. ETL loads the data warehouse (3NF or Data Vault model) and publishes marts (dimensional or otherwise) that users access. In a store and publish architecture, users do not access the data warehouse directly.
Re: Presentation Layer
Thank you, as always very helpful.
rajeshwarr59- Posts : 21
Join date : 2015-06-26
![-](https://2img.net/i/empty.gif)
» Dealing with deduplication, merging records, etc in the warehouse layer
» New Layer in DWH for Reporting
» Modeling Fact Tables that have direct relationships, but at a detail and not a dimension layer
» Do we need an additional layer on top of Datamart?
» Tracking Support Tickets: accumulating snapshot and transaction grain fact (a presentation question)
» New Layer in DWH for Reporting
» Modeling Fact Tables that have direct relationships, but at a detail and not a dimension layer
» Do we need an additional layer on top of Datamart?
» Tracking Support Tickets: accumulating snapshot and transaction grain fact (a presentation question)
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|