问一个DATA WAREHOUSE的问题,紧急!!!# Database - 数据库
s*u
1 楼
We are designing a data mart for "Vehicle" transaction details which include
the following
processes:
1. Vehicle moves from "Company" to "Dealer"
2. Vehicle can returned from "Dealer" to "Company"
3. Vehicle moves to "Customer" from "Dealer"
4. Vehicle can be returned by "Customer" to "Dealer"
The requirement is to show: We need to show how many days vehicle was with
Dealer (If point 2
happened then "Vehicle with dealer" equal to point 2 date minus point 1 date.
If point 3 type
transaction happe
the following
processes:
1. Vehicle moves from "Company" to "Dealer"
2. Vehicle can returned from "Dealer" to "Company"
3. Vehicle moves to "Customer" from "Dealer"
4. Vehicle can be returned by "Customer" to "Dealer"
The requirement is to show: We need to show how many days vehicle was with
Dealer (If point 2
happened then "Vehicle with dealer" equal to point 2 date minus point 1 date.
If point 3 type
transaction happe