hi everybody,
Please i need help for modelising a datawarehouse.
I am creating my first datawarehouse for a rent car company during my training period.
after analysing their needs, i select several measure that is :
-> number of car put in the park
(by month, by agence, by categorie and by type of car)
-> number of car Available
(by month, by agence, by categorie and by type of car)
->Day number of car located
(by car, by month, by agence, by categorie and by type of car)
->Day number of car detention
(by car, by month, by agence, by categorie and by type of car)
->Rate of use (Day number of car detention/Day number of car located )
->turn over
( by month, by agence, by categorie , by type of car, by type of client, By contract charged )
--> ...
Someone can he confirm me that i must create several table fact because certains measures can't be put together. that true that this question seems obvious but as i am never create datawarehouse, i don't want do a bad one.
So We do not have to hesitate to create as much facts tables than there is different measures? that true or logic instead. and so that will be several datamart because a datamart contains only one table fact?
Please i need help for modelising a datawarehouse.
I am creating my first datawarehouse for a rent car company during my training period.
after analysing their needs, i select several measure that is :
-> number of car put in the park
(by month, by agence, by categorie and by type of car)
-> number of car Available
(by month, by agence, by categorie and by type of car)
->Day number of car located
(by car, by month, by agence, by categorie and by type of car)
->Day number of car detention
(by car, by month, by agence, by categorie and by type of car)
->Rate of use (Day number of car detention/Day number of car located )
->turn over
( by month, by agence, by categorie , by type of car, by type of client, By contract charged )
--> ...
Someone can he confirm me that i must create several table fact because certains measures can't be put together. that true that this question seems obvious but as i am never create datawarehouse, i don't want do a bad one.
So We do not have to hesitate to create as much facts tables than there is different measures? that true or logic instead. and so that will be several datamart because a datamart contains only one table fact?