Presentation Layer

View previous topic View next topic Go down

Presentation Layer

Post  rajeshwarr59 on Tue Jan 05, 2016 7:30 pm

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

View user profile

Back to top Go down

Re: Presentation Layer

Post  BoxesAndLines on Wed Jan 06, 2016 9:09 am

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Presentation Layer

Post  ngalemmo on Wed Jan 06, 2016 12:33 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Presentation Layer

Post  rajeshwarr59 on Wed Jan 06, 2016 10:31 pm

Thank you, as always very helpful.

rajeshwarr59

Posts : 21
Join date : 2015-06-26

View user profile

Back to top Go down

Re: Presentation Layer

Post  Sponsored content


Sponsored content


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