Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to use Dimension in Spoon

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default How to use Dimension in Spoon

    Attachment: Database_Loyalty.pdf After studying the user's guide, I still have no idea about how to use Dimension, such
    as where is the position of Dimension in a ETL steps.
    I think it will be better to add an example in the Dimension section.
    Thanks.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: How to use Dimension in Spoon

    Attachment: Database_Loyalty.pdf Typically, you read source data, let's take for example a customer.
    Then you "enrich" that customer data with everything you can find: categories, types, code descriptions, ...
    Finally when you have all the fields that you want to put in the slowly changing dimension, you add the dimension step.

    What you can also do is populate a dimension and a fact table together, because the Dimension Lookup step also gives back a technical/surrogate key when doing updates.

    This is all documented, but of-course, basic knowledge of data warehousing, multi-dimensional modelling and slowly changing dimensions is required.

    In attachement, I included a presentation I did a couple of months ago for the Belgan Direct Marketing Assosiation (BDMA) on the subject of BI and data warehousing.

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: How to use Dimension in Spoon

    Last edited by MattCasters; 01-11-2007 at 07:27 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.