topic Re: Loading of data in fact table with several date fields in Talend Studio

Loading of data in fact table with several date fields

Anonymous — Sat, 16 Nov 2024 02:16:50 GMT

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

Re: Loading of data in fact table with several date fields

manodwhb — Mon, 01 Jun 2020 11:23:49 GMT

@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

Re: Loading of data in fact table with several date fields

Anonymous — Mon, 01 Jun 2020 13:14:10 GMT

Thank you @manodwhb