I have two separate data sources with effectively the same columns
- Date
- Vendor
- Campaign
- Ad group
- Keyword
- Impressions
- Spend
What I am trying to do is stitch the data together in a fact table in order to get a combined view of Impressions and Spend. However, as I am dealing with 2.5 million rows, as soon as I make a concatenated key to join the data =[Date]&[Vendor]&[Campaign]&[Ad Group]&[Keyword]
, my file size jumps from 11Mb to 100Mb, I assume due to the high level of the cardinality in my new column.
What I am wondering is, how can I get join this data together that would remove the need for this concatenated key? I have a date table in place if that helps, but would a method that would utilize a measure instead of a calculated column would be ideal.
Many thanks, Chris