Hello all and thank you for any assistance,
Still in onboarding so apologies if this is basic.
I have two dimension tables containing common information that are currently joined with fact tables that contain information regarding different digital marketing tactics for a common client advertising campaign. For example, Client A has a number of different commercials that they can run in different markets, and run those videos on YouTube and in Hulu. The two Fact Tables that I have are for YouTube and Hulu, but they are currently connected to two different Dimension Tables each containing campaigninternal, campaign, market, region, and client.
How would I go about merging the two tables so that my two Fact Tables can connect to only one Dimension Table?
Please sign in to leave a comment.