Currently, I am building fact table base my ODS tables and dimension tables.
My ODS Table like
Here, We facing issue to join all three table data in single fact table.
In this case we have three different total impression on each table. But in fact table we just add only single total impression. How we can calculate it and join then.
We tried different join technicians but didn't find perfect solution.
and your query to find impressions by advertiser looks like this:
inner join advertiser on advertiser.id = advertiser_id
inner join calendar on calendar.id = calendar_id
where calendar.cal_date = '2016-02-08'
group by advertiser.name;
If you attempt to carry totals anywhere else you will end up in a world of pain.
Asked in February 2016Viewed 2,177 timesVoted 6Answered 1 times