vermarajiv
Programmer
Guys, I see lot of talk about dimensions and facts(aggregations) and how they should be modelled. But in a datawarehouse, there are lots of requests to just display list of data from two different entities. How does that fit in the overall design. For eg I have two differen entities - Emp and Dept. If there is a requirement to find total employees in a dept in a certain salary range and also a requirement to list employees in a dept., I was thinking of a design that may look like this :
dimEmployee
EmpId
Dept
Name
etc...
dimDept
DeptId
Desc
Manager
etc....
fctEmpDept
empId
DeptId
Salary
But here, dept and Emp are linked with deptId in dimEmp table. Is that a valid design ?
dimEmployee
EmpId
Dept
Name
etc...
dimDept
DeptId
Desc
Manager
etc....
fctEmpDept
empId
DeptId
Salary
But here, dept and Emp are linked with deptId in dimEmp table. Is that a valid design ?