‘Data Mart vrs Data Warehouse’ Archives
LOGICAL DATA MART BENEFITS
Recently while researching on how to create a data mart logical, I found a very useful information in an article named as "On Target with Logical Data Marts" by - Rob Armstrong published in Teradata Magazine; If you have a database that lets you run complex queries, support large numbers of users simultaneously, and ask any question of any [...]
investments in data warehouses
Recently read in CMA preparation course, Since investments in data warehouses can be considerable companies often opt to create data-marts instead of a full blown data warehouse. A data mart is a department or subject specific mini-data warehouse. A data mart can be created much faster than a full integrated warehouse, but if organizations [...]
Product launch of Microstrategy 9 in Toronto
March 6th, 2009 4 comments I recently attended the product launch of Microstrategy 9. Microstrategy is breakthrough technology that for the first time, allows companies to support all levels of BI with one technology. ? Extends performance, scalability and efficiency of enterprise BI. ? Enables rapid development of departmental BI [...]
Microsoft’s Next Generation EDW Platform
March 8th, 2009 3 comments Recently I read a SQL Server Technical Article written by Stuart Frost, Group Manager, Data Warehousing Product Unit Microsoft Published: February 2009 Applies to: SQL Server 2008 and later. I am writing the overview of this upcoming new approach; This article basically introduced an attractive alternative to [...]
Stars, Snow Flakes, Fact Tables Schema for multidimensional Databases.
July 1st, 2008 No comments Stars, Snow Flakes, Fact Tables Schema for multidimensional Databases. Star Schema: The most common in which Data Warehouse contains 1 large central Fact Table containing bulk amount of data with no redundancy and set of smaller dimension tables, 1 for each dimension like Time, Geographic etc. Snow Flake [...]
Creating a Bank’s Account Summary like Report in SQL which can be be Formatted in Crystal Reports, Access/ Sql Server Reporting Services
March 4th, 2008 No comments Creating a Bank like Report in SQL Frequently we have to create a report in any reporting tools like Crystal Reports, Sq Server Reporting Server or MS Access which should give us account detail between 2 dates, as well as previous balance as of beginning date of the report, for example we an account summary between [...]
Time dimension necessary? If so, why?
February 1st, 2008 “When you build a data warehouse you must make a decision about the granularity of the data you want to present. In most cases you want to record your activity bases on each transaction. In other cases you may choose to use a daily level of granularity In case of time dimension if you have day as the finest level, users [...]
Data ware and Data mart
January 31st, 2008 No comments Before going into further details it will be worth describing the difference between Data warehouse and data mart. Information requirements of management at level should be the basis for preparing the Data mart. By creating data marts makes it easier to manage data warehouse projects, as after all when combing all [...]
