Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Warehouse data design for time-sheet management data. Expand / Collapse
Author
Message
Posted Monday, August 11, 2014 3:09 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 3:26 AM
Points: 533, Visits: 470
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, ...!!!
Post #1601716
Posted Wednesday, September 3, 2014 7:15 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 3:26 AM
Points: 533, Visits: 470
Can anybody suggest me on this ?
Post #1610014
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse