Datamartist gives you data profiling and data transformation in one easy to use visual tool.

Date archive for December, 2008

  • Degenerate Dimensions in Datamarts

    Not all dimensions are created equal.  A typical dimension is defined by a table that holds the reference data that is being joined to the fact data.  So in the fact table, for example, we have the product ID, or the product code, and in the product dimension table we have a single row for […]

    12/27/08 • (2)

  • Easy to use ETL

    As We’ve been creating Datamartist, we’ve been trying to avoid using acronyms to describe what it is, but when I’m talking to people who have a background in data warehousing, I only have to say “its an easy to use desktop ETL tool”, and suddenly they know what I am talking about. An Extract, Transform, Load (ETL) tool is […]

    12/05/08 • (0)

  • Data Warehouse vs Data Mart

    Very often, the question is asked- what’s the difference between a data mart and a data warehouse- which of them do I need? Data warehouse or Data Mart? Data Warehouse: Holds multiple subject areas Holds very detailed information Works to integrate all data sources Does not necessarily use a dimensional model but feeds dimensional models. […]

    12/02/08 • (8)