Hello friends, Any idea? Thanks On Fri, Jul 27, 2018 at 3:58 PM, deva namaste <[email protected]> wrote:
> Hello, > > I do have fact table with date column where dates are in this format > "YYYY-MM-DD" ( e.g. 2016-01-01). The same fact table is joined with date > dimension table same format column (and the other columns are year_no, > qtr_no, month_no, etc). > > My new data in fact table is coming in "2016-01-01 16:45:00" format (15 > mins intervals). > > How can I handle this situation? I do not want to have all detailed level > intervals in Date dimension since it will add lots of data. > > Any idea you would recommend? > (fact table format "YYYY-MM-DD HH24:MI:SS" will not be joined with > dimension table "YYYY-MM-DD" ) > > Thanks >
