Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
flyhigh15
Contributor III
Contributor III

Synthetic key , data model

Given Data Set is about Car with Purchase Date, Car Brand, Price Car Type Etc.  Find Car Type based on discrete Car Purchase Date. E.g if car purchased on 01-01-2021 then Car Type is  "Diesel Car - High CO Emission" (Avoid Synthetic Tables)
 
2 Replies
Usama
Creator
Creator

If "Purchase date" is equals to "Manufactured_Start_Date" then:

Car_Sales:

Purchase_Date   as  Date,

Car_Brand,

Price

Type:

Manufactured_Start_Date as Date,

Manufactured_Start_Date,

Manufactured_End_Date,

Car _Type

From Nothing - To Something - To Everything
flyhigh15
Contributor III
Contributor III
Author

can we use intervalmatch and left join to avoid synthetic table..?