Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Fact and Dimension Design

  1. #1
    Join Date
    Jul 2009
    Posts
    9

    Default Fact and Dimension Design

    I am totally done by this creatoi of dimension and fact tables.
    my fact table Design:
    ----------------------++------
    Product_Sur_Key Int,
    Contact_Mech_Id Int,
    Country_Geo_Id Int,
    Price decimal,
    Qty decimal,
    TotAmt Decimal

    my doubt is that price,qty,totamt should be coming from one of dimension tables..bcos in product dimension table i dont have that columns

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    It all depends... I've seen some strange designs over the years, if it works for you go with it

    - data warehousing is to make data available in a fast way for reports/analysis. Which reports/what analysis do you want to do on your data?... does your table design allow you to do what you want?
    If your answer is along the lines: I don't know, someone told me to make a star schema design and we'll figure out what to put the on the reports later... you'll probably hit a brick wall somewhere... and earlier than you think.

    - Normally you would define the grain of your fact table... your example doesn't reveal a lot . But I guess it's wrong... do you want to count quantities or single prices?

    btw this has nothing to do with PDI

    Regards,
    Sven

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.