Loading of data in fact table with several date fields

[Anonymous]

Hello,

Problem : load data to the fact table

i have multiple fields that contains DATE in other dimensions and i don't know which one to join with dim_time.

Example : Dim_A contains (id_dimA, ID,Date1, Date2)

Dim_B contains (id_dimB, ID, Date3)

Dim_Time(id_dimTime, date)

how i can do it

[manodwhb · Accepted solution]

@ahouri , you need to get to know the business knowledge on what to join between those tables and then do the lookups accordingly. probably you can try to do the below and you should use the same way in reporting layer or downstream layers.

Start date Key:- get id_dimTime lookup on Date1=date

End date Key:- get id_dimTime lookup on Date2=date

[Anonymous]

Thank you @manodwhb