Post reply

Warehouse data design for time-sheet management data.

  • August 11, 2014 at 3:09 am

    #288908

    Please suggest :

    I have to design a warehouse(DW) database for time-sheet management.

    Here is the OLTP Transaction data arrangement

    1-ProjectType ->(ID),ProjectTypeName

    2-ProjectTable ->(ID),ProjectTypeID,ProjectName

    3-Employee ->(ID),EmployeeName,EmployeeAddress3

    4-Division ->(ID),DivisionName

    4-TimesheetMain -> (ID),EmployeeID,fromDate,todate

    5-TimeSheetDetail -> (ID),TimeSheetMainID,HrsSpent,ProjectID

    Am I planning correctly ?

    DimDate (id,timeKey,year)

    Dim_Project (ID,ProjectID,ProjectTypeName,ProjectName)

    Dim_Employee (ID,EmployeeID,EmployeeName,DivisionName)

    fact_time (SurrogateKey,Dim_Employee.ID,Dim_Project.ID,fromdate,ToDate,HrsSpent,TimeKey)

    Please suggest a good design.

    Thanks once again, ...!!!

  • September 3, 2014 at 7:15 am

    #1742779

    Can anybody suggest me on this ?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply