We have one fact table which store vehicle sales records.
We have another table have all maintenance records of vehicle which are loaded on
Now our customer want to see the vehicle sales record with the last maintenance
So far we have a idea to populate one table with only the last maintenance record
for each vehicle, then consider this table as one dimension of vehicle sales. But
this depends on the ETL process.
What is the best practice to model this kind of requirement?