Sunday January 21st 2018

Categories

Insider

Archives

Data Mart Example

We would like to introduce an example  of data mart consisting of  rental properties. It demonstrate the drill down from geographic dimension which has hierarchy from state, city, town to zipcode level. Website is www.Cheaprent.org Data is stored in Sql server in a single table and is accessed by ASP Classic page and presented in a report manner , showing all the geographich information. In this website data feeds were received in Excel sheets which were transformed using Data Transformation Service in SQL  Server 2000. This data is weekly updated by this process.