Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hamzad_cne
Starting Member
1 Post |
 Posted - 2011-10-04 : 06:04:57
|
| Hi,I 'm working on a DataWarehouse where we store data about fleet management system.In our application, each truck is affected to one or more groups, and the affectation may change in time (each affectation has a start and end date). When we import data to the DataWarahouse, we need to save history about trucks affectation, i.e we need to see which truck is affected to which group(s) at a specific date in our reports.The simplest way is to save for each day (Date) the truck affectation to groups, which will result in a huge number of records (number of trucks X number of groups affected by truck X number of days working ) that's not convenient for us.Is there any way to optimize this importation process, while keeping the ability to generate such a report ? Thanks |
|
|
|
|
|
Parent-child relationships that change over time