Scribd Logo
Upload

Welcome to Scribd!

  • 17 views

    Task 1 Dimension Attributes Hierarchies Data Sources

    Uploaded by

    София Пинчук

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Task 1 Dimension Attributes Hierarchies Data Sources

    Uploaded by

    София Пинчук
    17 views2 pages

    Original Title

    w2_t1

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    17 views2 pages

    Task 1 Dimension Attributes Hierarchies Data Sources

    Uploaded by

    София Пинчук

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    Task 1

    Dimension Attributes Hierarchies Data Sources


    Cust_Key CustRegion (Country→State→City) ERP
    Customer Cust_Name Database
    City Email (top level domain  second
    Country level domain  local part)
    State
    Credit_
    Limit
    Email
    Term_Code
    Zip
    Cust_Loc_key CustRegion (Country→State→City) ERP
    CustLocation Cust_Name Database
    Cust_No(Remove the Email (top level domain  second
    numbering in level domain  local part)
    cust_name , add this
    as cust_no)
    City
    Country
    State
    Email
    Zip
    SalesAgent Sales_Agent_Id Country→State ERP
    Sales_Agent_Name Database
    State
    Country
    MachineType Machine_Type_Id ERP
    Manufacturer Database
    Model
    Rate_Per_hour
    Number_Of_Machine
    s
    Time Time_Id Year→Quarter→Month→Week→Day Standard
    Year Time
    Quarter Dimension
    Month Table for the
    Day data
    Week warehouse

    There are various time columns in the ERP Database and Other Sources

     Job (Contract Date,Date Promised)


     SubJob(Date_Prod_Begin,Date_Prod_End)
     Shipment(Actual_Ship_Date)
     Invoice(Requested_Ship_Date)
     Lead(Created_Date)
     Financial Cost Summary(Begin_Date,End_Date)
     Financial Sales Summary(Begin_Date,End_Date)

    Assuming Location_Name and Sales_Class_Desc are unique. Location tables and sales class
    tables are not required in warehouse.

    You might also like