Comments by ELHAMOUCHI (Top 1 by date)

I have 2 tables and dimension dim_Calendar_Start dim_Calendar_End dim_Calendar_start (id_temp_start, date_start, year, month, quarter, week) dim_Calendar_END (id_temp_END, date_end, year, month, quarter, week) FACT_TABLE (BTS date_Start_alarm, date_End_alarm, id_temp_Start, id_temp_End, numOfweek, T, a, pond, t_pond) I already filled fact table but I just have to fill id_temp-Start and id_temp_End after comparing with fact_table.date_Start_alarm dim_Calendar_Start.date_Start and fact_table.date_end_alarm with dim_Calendar_end.date_end